Author dataflows in the Power Apps Maker Portal
Important
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 |  Sep 10, 2019 |
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.