Author dataflows in the PowerApps Maker Portal

Important

Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned

Enabled for Public preview General availability
Admins, makers, or analysts, automatically This feature is released. Sep 10, 2019 Oct 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, Microsoft Flow, 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)