Use Power BI

Applies to Dynamics 365 for Customer Engagement apps version 9.x
Applies to Dynamics 365 for Customer Engagement apps version 9.x (on-premises)

The Power BI for Office 365 cloud service works with Dynamics 365 for Customer Engagement apps to provide a self-service analytics solution. Power BI automatically refreshes the Dynamics 365 for Customer Engagement apps 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 for Customer Engagement apps, sales, marketing, and service personnel in your organization have a powerful new way to work with Customer Engagement apps data.

Get started using Power BI with Dynamics 365 for Customer Engagement apps (online)

The Dynamics 365 for Customer Engagement apps 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.

    • Sales Analytics for Dynamics 365

    • Customer Service Analytics for Dynamics 365

    • Microsoft Dynamics 365 - Social Engagement

  3. For the Sales Analytics and Service Analytics content packs, enter the URL of your Dynamics 365 for Customer Engagement instance, such as https://OrganizationName.crm.dynamics.com, where OrganizationName is the organization name of your instance of Dynamics 365 for Customer Engagement apps, 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 Customer Engagement apps 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 for Customer Engagement apps, and click Next

  4. Under Authentication method, select oAuth2.

  5. Your Dynamics 365 for Customer Engagement apps 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 for Customer Engagement apps 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 for Customer Engagement apps 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 for Customer Engagement apps, 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 for Customer Engagement apps, see Add a Power BI dashboard on your personal dashboard.

Use Power BI Desktop to connect directly to your Dynamics 365 for Customer Engagement instance

You can connect to Dynamics 365 for Customer Engagement apps with Power BI Desktop to create custom Customer Engagement apps reports and dashboards for use with the Power BI service.

Requirements

  • Power BI service registration

  • Power BI Desktop.

  • Dynamics 365 for Customer Engagement instance

Connect to Customer Engagement apps

  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 Customer Engagement apps OData endpoint URL. It should look similar to this URL, where OrganizationName is the name of your Customer Engagement apps organization, and v8.1 is the version. Click OK.

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

Important

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 for Customer Engagement apps 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 for Customer Engagement 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 for Customer Engagement apps using Office Excel Power Query by selecting From Other Sources on the Power Query tab in Excel.

See also