Consuming external data by using Dataflows

The data for your solutions can come from very different sources: relational databases, on-premises data, analytics data, APIs, and even from regular files. This variety of data sources can be in any location or without an infrastructure to provide data.

Dataflows aim to be an instrument to gather all kinds of data sources into Dataverse. With this tool, you will be able to consolidate all the required data, related or not, into Dataverse, where you can then improve the collected information by adding views, relationships, and the like. Dataflows not only gather information but also allow you to transform it while doing it.

Using Power Query, the same technology used in Power BI, gives you a full set of features to shape your data. For more information about Power Query, please refer to https://docs.microsoft.com/en-us/power-query/power-query-what-is-power-query

Dataflows can run manually or on a schedule. They live in your environments...