Power BI Deployment Guide

275 December 11, 2023

1 Overview

This document provides an in-depth description of how to deploy the DynamicPoint Power BI report integration functionality.

2 Configure Power BI for Service Principal Access

The DynamicPoint portal Power BI embed leverages a service principal for authentication. Detailed instructions on leveraging this approach can be found on the following article: https://learn.microsoft.com/en-us/power-bi/developer/embedded/embed-service-principal

Steps 1-4 should be followed directly from the referenced article.

Step 1 – Create an Azure AD app

The following notes apply to step 1:

  • For Redirect url use: https://portal.dynamicpoint.com
  • Note: Make sure you copy and save the Application ID and Secret which are provided by the end of the registration. You can retrieve the Application ID later from the app registration in Azure, but if you lose the secret you will have to create a new one manually.

Steps 3-4

Directly follow the Microsoft support article.

Step 5

Skip this step and move on with portal configuration.

3 Configure Power BI Report in DynamicPoint Portal

Create Report Service configuration

Make sure the Report Service Provider is set to Power BI, and the rest of the configuration fields will show up.

Tenant ID

To retrieve tenant id, login to azure portal and go to Azure Active Directory. You can find the tenant id as on the screen shot:

Application ID

From Azure AD go to App registrations from the left menu and look for the app that was registered using the Power BI setup tool.

Application id can be found next to the name of the application.

Application Secret

To generate new secret, click on the app registration and from the left menu go to Certificates & Secrets:

Click on New client secret to generate one and save it somewhere as it will not be available for reading once it is generated.

Workspace ID

From the top row click the settings icon and then click Admin portal. Then click Workspaces from the Admin portal menu, the context menu of the needed workspace and then Details:
The details popup contains the workspace id:

Report ID

In Power BI environment, click workspaces, then click the workspace to which the report is published, then click the Reports tab. For the needed report click the Share icon:

The Share dialog contains Report link in which you can find the report id:
The url looks like this:
https://app.powerbi.com/links/hJfwNV3A84?ctid=9409a44d-fc40-4daf-8cbd-33a8d837f52c&pbi_source=linkShare

The report id is the one that is in bold.

Passing Parameters

When specifying parameters to pass to the Power BI report, all filters must be denoted in the Table/Field format.