Use Power BI

Applies to Dynamics 365 (online), version 9.x
Applies to Dynamics 365 (online), version 8.x

The Power BI for Office 365 cloud service works with Dynamics 365 to provide a self-service analytics solution. Power BI automatically refreshes the Dynamics 365 (online) data displayed. With Power BI Desktop or Office Excel Power Query for authoring reports and Power BI for sharing dashboards and refreshing data from Dynamics 365 (online), sales, marketing, and service personnel in your organization have a powerful new way to work with Dynamics 365 data.

Get started using Power BI with Dynamics 365 (online)

The Dynamics 365 content packs for Power BI cloud service allow you to easily access and analyze your sales, service, or marketing data.

To create a Power BI dashboard using a content pack, follow these instructions.

  1. If you haven't already done so, register with Power BI.

  2. After you have signed in to Power BI, in the Datasets area click Get Data, under Services click Get, and then select from the following content packs.

    • Dynamics 365 (online) Sales Manager

    • Dynamics 365 (online) Service Manager

    • Dynamics Marketing

  3. For the Sales Manager and Service Manager content packs, enter the URL of your Dynamics 365 (online) instance, such as https://OrganizationName.crm.dynamics.com, where OrganizationName is the organization name of your instance of Dynamics 365 (online), and click Next.

    Note

    If your data center is outside of North America the crm.dynamics.com domain name may be different, such as crm2.dynamics.com, crm3.dynamics.com, crm4.dynamics.com, etc. To find the domain name, in the Dynamics 365 web app go to Settings > Customizations > Developer Resources. The URLs listed will indicate the correct domain name.

    For the Marketing content pack, enter the URL as https://OrganizationName.marketing.dynamics.com/analytics, where OrganizationName is the organization name of your instance of Dynamics 365 (online), and click Next

  4. Under Authentication method, select oAuth2.

  5. Your Dynamics 365 (online) organization data is imported and several visualizations become available.

Tip

If the content pack you select does not open in your web browser, in the left pane of your Power BI workspace click the content pack under Dashboards.

Content packs available for download.

The Dynamics 365 content packs support the default out-of-box entities. However, you can customize the following content packs by downloading the .PBIX file and then using Power BI Desktop to customize the content pack before uploading it to the Power BI service.

Embed Power BI visualizations on personal dashboards

Before users can embed Power BI visualizations on personal dashboards, the organization-wide setting must be enabled.

Note

This feature was first introduced in CRM Online 2016 Update 1.

By default, Power BI visualization embedding is disabled and must be enabled before users can embed them in personal dashboards.

Enable Power BI visualizations in the organization

  1. Sign-in to Dynamics 365 as a user with the system administrator security role.

  2. Go to Settings > Administration > System Settings.

  3. On the Reporting tab in the Allow Power BI visualization embedding option, select Yes to enable or No to disable.

  4. Click OK.

To learn more about how to add Power BI tiles to personal dashboards in Dynamics 365, see Embed Power BI tiles on your personal dashboard .

To learn more about how to add Power BI dashboards to personal dashboards in Dynamics 365, see Add a Power BI dashboard on your personal dashboard.

Use Power BI Desktop to connect directly to your Dynamics 365 (online) instance

You can connect to Dynamics 365 (online) with Power BI Desktop to create custom Dynamics 365 reports and dashboards for use with the Power BI service.

Requirements

  • Power BI service registration

  • Power BI Desktop.

  • Dynamics 365 (online) instance

Connect to Dynamics 365 (online)

  1. Start Power BI Desktop.

  2. From the Home tab, click Get Data, and then click More.

  3. In the Get Data list, select Dynamics 365 Online.

  4. Enter the Dynamics 365 (online) OData endpoint URL. It should look similar to this URL, where OrganizationName is the name of your Dynamics 365 (online) organization, and v8.1 is the version. Click OK.

    https://OrganizationName.api.crm.dynamics.com/api/data/v8.1

Important

Currently, the Power BI service isn’t compatible with the Dynamics 365 (online) version 9.0 OData endpoint. When you try to use the version 9.0 OData endpoint with the Power BI service the error message “The feed's metadata document appears to be invalid” is displayed. To work around this incompatibility, use the Dynamics 365 (online) version 8.2 OData endpoint.For more information about the different endpoint versions, see Web API URL and versions.

Tip

You can find your OData endpoint URL in the Dynamics 365 web client. Go to Settings > Customizations > Developer Resources and locate the URL under Instance Web API.

  1. In the Access an OData feed dialog click Organizational account, and then click Connect.

    Note

    If you aren't signed in to your Dynamics 365 (online) instance, click Sign-in on the Access OData feed dialog before you click Connect.

  2. The organization database entity tables appear in the Power BI Desktop Navigator window. You can select both default and custom entities. For more information about creating reports with Power BI Desktop, see Power BI Support: Report View in Power BI Desktop.

    Select entity table

    Tip

    You can use similar steps to connect to Dynamics 365 (online) using Office Excel Power Query by selecting From Other Sources on the Power Query tab in Excel.

See also