Use Power BI to connect to Microsoft Dataverse with DirectQuery

Important

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

Feature details

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.

See also

View entity data in Power BI (docs)