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.
Power Platform Dataflows has certain limitations. E.g. in order to set lookup fields for a Dataverse table you will need to use alternate keys (which is setup on the Dataverse tables). Alternatives to using Power Platform Dataflows might be other native data import tools for simple migration jobs and a third-party tool like SSIS Kingswaysoft or Scribe for more complex data migrations or integration scenarios.
How to get started
Navigate to Maker Portal and make sure you have chosen the intended environment. Go to Data -> Dataflows in order to create a new dataflow.
Tips
Detailed error messages from dataflow runs can be found in Admin Center under Data Integration.
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