Difference between revisions of "Power Platform dataflows"

From Power Wiki
Jump to navigation Jump to search
Line 27: Line 27:
 
== Microsoft Resources ==
 
== Microsoft Resources ==
 
* [https://docs.microsoft.com/en-us/power-platform-release-plan/2019wave2/cdm-data-integration/power-platform-dataflows/?WT.mc_id=DX-MVP-5003780 Power Platform Dataflows Overview]
 
* [https://docs.microsoft.com/en-us/power-platform-release-plan/2019wave2/cdm-data-integration/power-platform-dataflows/?WT.mc_id=DX-MVP-5003780 Power Platform Dataflows Overview]
 +
* [https://docs.microsoft.com/en-us/powerapps/maker/data-platform/using-dataflows-with-on-premises-data Using an on-premises data gateway in Power Platform Dataflows]
 
* [https://docs.microsoft.com/en-us/powerapps/developer/data-platform/dataverse-odata-dataflows-migration/?WT.mc_id=DX-MVP-5003780 Migrate data between Microsoft Dataverse environments using the dataflows OData connector]
 
* [https://docs.microsoft.com/en-us/powerapps/developer/data-platform/dataverse-odata-dataflows-migration/?WT.mc_id=DX-MVP-5003780 Migrate data between Microsoft Dataverse environments using the dataflows OData connector]
  

Revision as of 18:05, 23 March 2021

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.

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).

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.

Microsoft Resources

Community Resources