Consuming external data by using Dataflows

Your solution’s data can come from various sources: relational databases, on-premises data, analytics data, APIs, and even regular files. This variety of data sources can come from 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.

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