M365Con 2027 – free online conference · 11–22 Jan 2027 · 120 sessions m365con.net

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.

◆ PRODUCTPower Platform dataflowsM365.FM
Title graphic: Power Platform dataflows (Product)

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.

TypeProduct
DocumentationPower 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:

All relationships of Power Platform dataflows, grouped by type of relationship:

Part of

Offerings of which Power Platform dataflows is a part:

Glossary

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:

Sources

Maintained by Mirko Peters (Microsoft MVP) · Last updated: