Tag Archives: Dataflow

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.

 

1