Power BI Dataflow – Cheat Sheet

ByHariharan Rajendran

Power BI Dataflow – Cheat Sheet

This post will give you the overall information about Power BI dataflow.

 

A- Create app workspace to create dataflows

B – Click create and choose dataflow which will allow you to create entity. Create entity using Power Query online. If you use on-premises data then choose the gateway. Apply the transformations and create the entity and name the dataflow

C – Option to create computed entity – the main entity should be enabled load. IN computed entity the data are stored on Azure data lake store gen 2 and all the computations will happened on the stored data not from data source. Also able to create linked entity.

D – Apply the ML & AI features to the entities.

E – Can apply incremental refresh on entity level and schedule refresh on dataflow level

F – All the dataflow components are stored on data lake store as a structure.

G – Entities are nothing but tables which can be used on the Power BI desktop using Power BI Dataflow connector and build the dataset and reports.

 

About the Author

Hariharan Rajendran author

Hariharan Rajendran is a MVP in Data Platform and Microsoft Certified Trainer with 10+ years of experience in Database, BI and Azure platforms. Hariharan is also an active community leader, speaker & organizer and leads the Microsoft PUG (Power BI User Group – Chennai), SQLPASS Power BI Local Group – Chennai and an active speaker in SQL Server Chennai User Group and also a leader in Data Awareness Program worldwide events. Hariharan also frequently blogs (www.dataap.org/blog), provides virtual training (on ad-hoc basis) on Microsoft Azure, Database Administration, Power BI and database development to worldwide clients/audience.

Leave a Reply

96 − 90 =