Configure Power BI template apps to work with Dynamics 365 Sales

You must perform the following steps to configure Sales Analytics for Dynamics 365 Sales or Process Analytics for Dynamics 365:

  1. Review the prerequisites.
  2. Install the Power BI template app.
  3. Connect your Dynamics 365 Sales organization to the Power BI template app.
  4. Configure the refresh frequency for the Power BI dataset.
  5. Publish the application within your organization.
  6. Enable Power BI reporting in the Common Data Service platform (optional).
  7. Add the Power BI Dashboard to the Sales Hub app (optional).

Step 1: Review prerequisites

Review the following prerequisites before configuring the Power BI template apps:

  • You have administrative privileges for Dynamics 365 and Power BI.
  • You have a Power BI Pro license for all users of the reports or dashboards in the Power BI template apps.

Step 2: Install the Power BI template app

  1. Sign in to the Power BI app as an administrator.
  2. Open the Sales Analytics template app link. 
  3. Install the Power BI template app.

4. After the Power BI template app is installed, the app configuration options page is displayed.

App configuration options page

Step 3: Connect your Dynamics 365 Sales organization to the Power BI template app

  1. On the Power BI template app configuration options page, select Connect.
Connect to data

2. On the connect data page, enter the URL for your Dynamics 365 organization, and then select Next.

3. For Authentication method, select OAuth2 and for Privacy level, select Organizational. Select Sign in.

4. Enter your Dynamics 365 Sales credentials, and then select Enter.

When you’re signed in, the existing report will be updated with the data from your organization.

Step 4: Configure the refresh frequency for the Power BI dataset

After you connect the Power BI template app with Dynamics 365 Sales, you need to configure the refresh frequency on the Power BI dataset to update reports and dashboards properly.

  1. Sign in to Power BI as an administrator.
  2. Go to the Power BI template app workspace.
  3. On the Datasets tab, select Settings.

4. Under Scheduled refresh, turn on the Keep your data up to date toggle.

Scheduled refresh

Step 5: Publish the application within your organization

You must share the configured application with your entire organization for users to view the dashboards and reports by using their own Power BI Pro accounts.

1.On the app workspace, select Update app.

Update app

2. On the Permissions tab, select Entire organization, and then select Update app.

Permissions tab

The app is now available to install for all individuals in your organization.

Step 6: Enable Power BI reporting in the Common Data Service platform

As an administrator, you must enable Power BI reporting in the Common Data Service platform for sales managers to view the dashboards in the Sales Hub app.

  1. Sign in to the Common Data Service platform, and then go to Settings.
  2. Select Administration > System Settings.
  3. On the Reporting tab, turn on the Allow Power BI visualization embedding toggle.
System settings

Step 7: Add Power BI dashboards to the Sales Hub app

Each sales manager must configure their environment to integrate the Sales Analytics for Dynamics 365 Sales dashboard.

  1. Sign in to Dynamics 365 Sales, and then open the Sales Hub app.
  2. Under My Work, select Dashboards.
  3. Select New > Power BI Dashboard.
New Power BI Dashboard

4. For Workspace, select Sales Analytics for Dynamics 365 Sales. For Dashboard, select Sales Pipeline.

Power BI Dashboard properties

5. Select Save, and then select Close.

Power BI Dashboard properties

The Sales Analytics for Dynamics 365 Sales dashboard is now available in Dynamics 365.

8 thoughts on “Configure Power BI template apps to work with Dynamics 365 Sales

  1. Greetings from Los angeles! I’m bored to death at work so I decided to browse your site on my iphone during lunch break. I love the info you present here and can’t wait to take a look when I get home. I’m surprised at how fast your blog loaded on my mobile .. I’m not even using WIFI, just 3G .. Anyhow, wonderful blog!

    Liked by 1 person

  2. Hello! This is my first visit to your blog! We are a team of volunteers and starting a new project in a community in the same niche. Your blog provided us useful information to work on. You have done a outstanding job!

    Liked by 1 person

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.