Power Platform dataflows
| Use Cases | Load data into Dataverse or Azure Data Lake |
|---|---|
| Public preview | |
| General availability | |
| MS Docs | Power Platform Dataflows |
| MS Learn |
With Power Platform dataflows you can load data into Microsoft Dataverse from several different sources and transform the data with Power Query as part of the loading process. Connect to a data source (not to be mixed up with the connectors for e.g. Power Automate) and start the transformation process, load into Dataverse or an Azure Data Lake. Use an on-premises data gateway in order to connect to data sources on-premises (e.g. SQL Server on-premises).
Power Platform dataflows can be extended to Azure Data Factory dataflows.
How to get started
History
Power BI dataflows were launched into Public Preview in November 2018 and hit General Availability within Power BI in March 2019. Power Platform dataflows brings dataflows to Power Platform and let you get data into Microsoft Dataverse (or Azure Data Lake Gen2).
Microsoft Resources
- Power Platform Dataflows Overview
- Migrate data between Microsoft Dataverse environments using the dataflows OData connector
Community Resources
- Dataflow articles by Carina M. Claesson
- Dataflow articles by Thomas Sandsør
- Dataflow articles by Olena Grischenko
- Power Platform Dataflows by Alex Shlega