Use Power BI to connect to Microsoft Dataverse with DirectQuery

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Power Platform product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
Admins, makers, marketers, or analysts, automatically Jun 30, 2020 Dec 10, 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

Microsoft Dataverse support for Power BI Direct Query reaches general availability (blog)

View entity data in Power BI (docs)