View table data in Power BI Desktop

Note

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.

Important

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.

Prerequisites

View table data

  1. Sign into Power Apps, and then select the appropriate environment from the top-right corner.

  2. 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.

  3. Open the .pbids file to access it in Power BI Desktop.

  4. 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.

    Sign in to connect to your environment

  5. 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.

    table rows displayed example

  6. 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.

Note

SQL options, such as a T-SQL queries aren’t supported.

See also

Use SQL to query data

Note

Can you tell us about your documentation language preferences? Take a short survey.

The survey will take about seven minutes. No personal data is collected (privacy statement).