View entity data in Power BI Desktop (Preview)

[This topic is pre-release documentation and is subject to change.]

You can use Power BI Desktop to view entities in Common Data Service. The entity record data that you can access from your environment is ready-only. Data access uses the Common Data Service security model that is the same used to access entity record data using a Power Apps app.

Important

  • This is a preview feature, and isn't available in all regions.
  • Preview features aren’t meant for production use and may have restricted functionality. These features are available before an official release so that customers can get early access and provide feedback.

Prerequisite

For this preview, to enable the Tabular Data Stream (TDS) endpoint for Common Data Service in an environment you must be an administrator and perform the following steps:

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

  2. Verify that your environment has at least version 9.1.0.17437. To do this, select the Settings gear on the toolbar, and then select Advanced Settings. Then, on the new browser tab that opens select the Settings gear on the toolbar, and then select About.

  3. Enable the TDS endpoint feature in Power Platform admin center. For more information, see the TDS endpoint (Preview) setting in Manage feature settings.

View entity 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 Entities, 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.

    Note

    If you don't have the Analyze in Power BI option in your Power Apps environment, you don't yet have access to the SQL connection feature.

  3. Open the .pbids file to access it in Power BI Desktop. Don’t have Power BI Desktop? Get it now.

  4. The pbids file is loaded in Power BI Desktop. In the SQL Server database dialog box, select Microsoft account, select Sign in, and then in the browser window that appears enter your credentials.

  5. In the SQL Server database dialog box in Power BI Desktop, select Connect.

    The environment appears in the Power BI Desktop Navigator window. Expand it to view the entity tables available to analyze. Select an entity to view its data.

Note

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

For more information about Power BI Desktop, see Get started with Power BI Desktop.

See also

Use SQL to query data