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.

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.

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.

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.

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

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.

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.

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

5. Select Save, and then select Close.

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