{"id":26854,"date":"2020-11-09T13:52:00","date_gmt":"2020-11-09T12:52:00","guid":{"rendered":"https:\/\/alistar.net\/?p=26854"},"modified":"2026-10-02T16:56:17","modified_gmt":"2026-10-02T14:56:17","slug":"power-bi-data-flow","status":"publish","type":"post","link":"https:\/\/alistar.net\/en\/blog\/power-bi-dataflow\/","title":{"rendered":"Power BI Dataflow"},"content":{"rendered":"

What are the capabilities and limitations of Power BI Dataflows? In this blog post, I\u2019ll tell you more about how Power BI Dataflows work. <\/p>\n\n\n\n

What is Power BI Dataflow?<\/h2>\n\n\n\n

With Power BI Dataflow, you can access data from various sources within the online Power BI environment. The data is retrieved from the source and stored in an Azure Data Lake. Transformations can be applied to the data, after which the output of the data flow can be used within Power BI to create a dataset. The data must then be modeled within the dataset. Various reports can then be built based on the dataset. <\/p>\n\n\n\n

Building a Dataflow<\/h2>\n\n\n\n

A data flow is created in the online Power BI environment. Multiple data flows can be created within a workspace. When creating a data flow, you can choose from a wide variety of sources, including on-premises sources that can be accessed through the gateway. <\/p>\n\n\n\n

After a table or query has been added to the data flow, various transformations can be applied to the data. Microsoft\u2019s strength here is that the interface is virtually identical to the one used to access data in Power BI. <\/p>\n\n\n\n

Scheduling a Dataflow<\/h2>\n\n\n\n

You can specify when the data flow should be refreshed through its properties. The downside here is that only the entire data flow can be refreshed; it is not possible to refresh only specific tables. This can potentially be resolved by using multiple separate data flows that can later be recombined using linked entities or in a dataset. However, a Power BI Premium license is required for incremental data loading. <\/p>\n\n\n\n

Using a Dataflow <\/h2>\n\n\n\n

Within Power BI, a data flow can be used as a source for assembling and modeling one or more datasets. Currently, however, Power BI Desktop must still be used for this purpose. It is not yet possible to create a dataset from a data flow within the online Power BI environment. After adding the tables, you can apply the usual transformations here as well. However, we recommend applying as many transformations as possible in a single location\u2014this is more efficient and keeps things organized. <\/p>\n\n\n\n

License<\/h2>\n\n\n\n

Dataflows is available with a Pro license or higher. Users with a Power BI Free license cannot use Dataflows. However, some features are only available with a Power BI Premium license. The main features to which this applies are: <\/p>\n\n\n\n