Difference between revisions of "Power Platform dataflows"
| (6 intermediate revisions by 2 users not shown) | |||
| Line 4: | Line 4: | ||
|publicpreview = | |publicpreview = | ||
|generalavailability = | |generalavailability = | ||
| − | |msdocs = [https://docs.microsoft.com/en-us/power- | + | |msdocs = [https://docs.microsoft.com/en-us/power-query/dataflows/overview-dataflows-across-power-platform-dynamics-365 Power Platform Dataflows] |
|mslearn = | |mslearn = | ||
}} | }} | ||
| Line 12: | Line 12: | ||
Power Platform dataflows can be extended to Azure Data Factory dataflows. | 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 == | == 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). | 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 [https://make.powerapps.com Maker Portal] and make sure you have chosen the intended environment. Go to Data -> Dataflows in order to create a new dataflow. | ||
| + | |||
| + | <div class="pw-box info"> | ||
| + | = Tips = | ||
| + | Detailed error messages from dataflow runs can be found in Admin Center under Data Integration. | ||
| + | </div> | ||
== Microsoft Resources == | == Microsoft Resources == | ||
| − | * [https://docs.microsoft.com/en-us/power-platform- | + | * [https://docs.microsoft.com/en-us/power-query/dataflows/overview-dataflows-across-power-platform-dynamics-365 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] | ||
Latest revision as of 08:46, 10 March 2022
| 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
- Power Platform Dataflows Overview
- Using an on-premises data gateway in Power Platform Dataflows
- 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