Power Platform dataflows
Product
Dataflows in Microsoft Power Platform use Power Query to ingest, transform and load data into Dataverse or other destinations, on demand or on a schedule.
Relationships
Power Platform dataflows is a product and part of Power Platform.
Description
Power Platform dataflows are a self-service, cloud-based data preparation technology in Microsoft Power Platform. They are built on Power Query and are used to ingest data from a source, transform it and load the result into a destination such as Microsoft Dataverse, a Power BI workspace or an organization's Azure Data Lake Storage account. Dataflows are part of Power Platform and can run on demand or on a schedule.
The main purpose of a dataflow is to keep transformation logic in one central place, separate from the modeling and visualization layer in Power BI. Because the prepared tables are stored centrally, several solutions can reuse them instead of each report or app repeating the same Power Query code. Other services read the results through Dataverse, the dataflow connector or the data lake. According to Microsoft Learn, these consumers include Power BI, Power Apps, Power Automate and Dynamics 365 applications.
In terms of sources, the documentation lists more than 80 supported data sources. Sources that sit on premises require an on-premises data gateway. The transformation step uses the Power Query experience, which means that data shaping tasks such as cleaning, combining and reshaping tables are defined in the same query language used elsewhere in the Microsoft data stack.
Typical scenarios named in the documentation include migrating legacy data into Dataverse, replacing ETL tooling when building a data warehouse or star schema, and avoiding duplicated Power Query code across reports. Dataflows are therefore relevant both for application builders who need data in Dataverse and for analytics teams who want a shared, reusable preparation layer.
On licensing, no dataflow-specific license is required. The feature is covered by the licensing of Power Apps, Power BI or Dynamics 365 Customer Insights. Microsoft Learn also notes a generation distinction on the Power BI side: Power BI dataflow Gen1 is described as legacy and receives no new features, while Gen2 is recommended for Premium customers with Fabric access.
The M365.FM episode "Migrate Dataverse Data Between Environments Safely" lists Power Platform Dataflows among several migration paths for Dataverse data, alongside the Dataverse Migration Utility, Azure Data Factory and third-party ETL solutions. The episode says the right path depends on scale and complexity, and that complex data types and relationships such as option sets, lookups, polymorphic lookups and hierarchies require careful mapping to preserve integrity and behavior.
The episode "Power Apps Code Apps - Simply Explained" mentions dataflows in the context of connecting Power Apps Code Apps with other services. It names Power Automate cloud flows for synchronizing data and Power Platform dataflows for data management across environments as examples of such integrations. Taken together, the episodes position dataflows as one data movement and preparation option within the wider Power Platform, used next to Dataverse, Power Automate and other tools rather than as a replacement for them.
Overview compiled with AI from M365.FM episodes and the facts on this page. You can improve it with the edit button below.
| Type | Product |
|---|---|
| Documentation | Power Platform dataflows – Microsoft Learn learn.microsoft.com |
Frequently asked questions
Questions marked with AI were written with AI from the facts on this page.
What are Power Platform dataflows? (AI)
They are a self-service, cloud-based data preparation technology built on Power Query. They ingest, transform and load data into Dataverse, a Power BI workspace or Azure Data Lake Storage, and can run on demand or on a schedule.
Do Power Platform dataflows need a separate license? (AI)
According to Microsoft Learn, no dataflow-specific license is required. The feature is covered by the licensing of Power Apps, Power BI or Dynamics 365 Customer Insights.
How do dataflows relate to Dataverse migration? (AI)
The episode "Migrate Dataverse Data Between Environments Safely" lists Power Platform Dataflows as one of several migration paths, together with the Dataverse Migration Utility, Azure Data Factory and third-party ETL solutions.
Related topics in brief
Topics linked to Power Platform dataflows, each briefly explained:
- Power Platform – Low-code tool by Microsoft · Part of
Microsoft's low-code family consisting of Power Apps, Power Automate, Power BI, Power Pages and Copilot Studio. Together with Dataverse it lets business users build apps, automations, reports and agents.
All relationships of Power Platform dataflows, grouped by type of relationship:
Part of
Offerings of which Power Platform dataflows is a part:
Community wiki
Short info above, community knowledge below: add practical tips, examples or corrections. New contributions are reviewed first; trusted members publish directly.
Experts and companies for this topic
Nobody has listed this topic yet. Add it to your profile.
Experts on related topics
Experts on topics related to Power Platform dataflows, each with the topic that connects them:
- Mirko Peters ✔ · via Power Platform
- Marcel L. · via Power Platform
- Elliot M. · via Power Platform
- Radhika P. · via Power Platform
Sources
- Power Platform dataflows – Microsoft Learn learn.microsoft.com
Maintained by Mirko Peters (Microsoft MVP) · Last updated: