Consuming external data by using Dataflows

The data for your solutions can come from various sources, such as relational databases, on-premises data, analytics data, APIs, and even regular files. These sources can be located anywhere and may not have the infrastructure to provide data.

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

Power Query, the same technology used in Power BI, helps with these transformations, giving you a complete 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...