Difference between revisions of "Power Platform dataflows"
| Line 1: | Line 1: | ||
| + | {{Infobox features | ||
| + | |title = Power Platform Dataflows | ||
| + | |usecases = Load data into Dataverse or Azure Data Lake | ||
| + | |publicpreview = | ||
| + | |generalavailability = | ||
| + | |msdocs = [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] | ||
| + | |mslearn = | ||
| + | }} | ||
| + | |||
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. | 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. | + | 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 can be extended to Azure Data Factory dataflows. | ||
Revision as of 17:47, 23 March 2021
| 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.
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
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