Use Power BI to connect to Microsoft Dataverse with DirectQuery
Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned
|Enabled for||Public preview||General availability|
|Admins, makers, marketers, or analysts, automatically||Jun 30, 2020||Dec 2020|
Power BI users have more options when connecting to Microsoft Dataverse environments. With this feature, Power BI users can use import or DirectQuery when retrieving data. When working with frequently changing data, using a DirectQuery connection retrieves data when the report is loaded as well as when the user opens the report. This will only return data to the user who has permission using the Dataverse security model.
This connector is using the Tabular Data Stream (TDS) endpoint for the Dataverse environment. This endpoint enables a better relationship discovery in the Power BI dataset model. In addition, complex data types, such as lookups, option sets, and currency, are flattened for easy consumption in the model.
View entity data in Power BI (docs)