Author dataflows in the Power Apps Maker Portal


This content is archived and is not being updated. For the latest documentation, see Microsoft Power Platform product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
Admins, makers, or analysts, automatically This feature is released. Sep 10, 2019 This feature is released. Nov 15, 2019

Feature details

Power Platform dataflows are familiar and simple to author. The authoring experience is based on Power Query, which millions of customers use in several Microsoft products, including Power BI, Microsoft Excel, Analysis Services, Power Automate, and Common Data Service.

Power Platform dataflows are a no-code experience for connecting, reshaping, and combining data from hundreds of data sources. They support both cloud and on-premises data sources via the on-premises data gateway. The breadth of data connectivity options is one of the strongest differentiators that Microsoft has in this space.

Power Platform dataflows are easily composable, meaning that users can define dataflows that load one or more entities into their data lake and keep them refreshed on a schedule.

Users can also reference other Azure Data Lake entities (their own or those that other users create) in multiple dataflows to compose new entities.

When you refresh the root entities, Power Platform dataflows refresh all dependent entities without any additional configuration. This allows users to easily build multiple ETL pipelines that are automatically synchronized, without having to deal with advanced configurations. Traditionally, this task needed professional ETL developers. This feature gives millions of data analysts a frictionless experience without requiring additional skills.

See also

Create and use dataflows in the Power Platform (docs)