Author dataflows in the Power Apps Maker Portal
|Enabled for||Public preview||General availability|
|Admins, makers, or analysts, automatically||Sep 10, 2019||Nov 15, 2019|
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.