View table data in Power BI Desktop
Effective November 2020:
- Common Data Service has been renamed to Microsoft Dataverse. Learn more
- Some terminology in Microsoft Dataverse has been updated. For example, entity is now table and field is now column. Learn more
This article will be updated soon to reflect the latest terminology.
This feature has been re-enabled in the majority of regions. Please resume testing, and provide feedback. We thank you for your patience and feedback.
You can use Power BI Desktop to view tables in Microsoft Dataverse. The table row data that you can access from your environment is read-only. Data access uses the Dataverse security model that is the same used to access table row data using a Power Apps app.
- Enable the Tabular Data Stream (TDS) endpoint. More information: Manage feature settings.
- Power BI Desktop. Get it now
View table data
Sign into Power Apps, and then select the appropriate environment from the top-right corner.
On the left navigation pane expand Data, select Tables, and then select Analyze in Power BI on the command bar.
The pbids file for your environment is downloaded to your browser’s default download folder.
Open the .pbids file to access it in Power BI Desktop.
The pbids file is loaded in Power BI Desktop. In the dialog box, select Organizational account, select Sign in, and then in the browser window that appears select or enter your credentials.
In the dialog box in Power BI Desktop, select Connect.
The environment appears in the Power BI Desktop Navigator window. Expand it to view the tables available to analyze. Select a table to preview its data.
After you're finished selecting the tables you want to analyze, select Load to build a report.
For more information about Power BI Desktop, see Get started with Power BI Desktop.
SQL options, such as a T-SQL queries aren’t supported.