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 |
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.
Microsoft Dataverse support for Power BI Direct Query reaches general availability (blog)
View entity data in Power BI (docs)