Power BI

Power BI integration setup details

To connect Masthead to your Power BI instance, you need to create a service principal and grant it Power BI Admin API access, allowing the Masthead application to access Power BI.

There are 4 steps to integrate Masthead to Power BI:

1. Create a service principal app in Azure

2. Create Azure Entra ID security group

3. Grant security group the access to Power BI APIs

4. Configure Power BI integration in Masthead

Step1. Create a service principal app in Azure

1. Login to your Azure Portal, and choose App Registrations (search for 'App registration').

1. Click on the New Registration.

1. Name registration 'masthead-powerbi-integration-app'. Click Register.

1. After successful app registration, an Overview page will display app details. Copy Application (client) ID and Directory (tenant) ID values in a safe place, we will use it later.

1. From the menu 'Manage' open the drop down and click on 'Certificates & secretes'. Click on 'New client secret' button

1. Fill the name of the secret as 'masthead-powerbi-integration-app-secret' and click 'Add' button.

1. After secret successfuly created, copy the value of the secret in a safe place, we will use it later.

Step 2. Create Azure Entra ID security group

1. Open 'Microsoft Entra ID' menu

1. Click Add -> Group button

1. Set Group type - Security, and Group name - masthead-powerbi-security-group. Click Create button.

1. Open the newly created group (naviagate to the menu Groups -> All groups and click on the masthead-powerbi-security-group group).

1. Navigate to the Members menu and click on 'Add members'

1. Search for 'masthead-powerbi-integration-app' and select check box to the left. Click on 'Select' button

Step 3. Grant security group the access to Power BI APIs

1. Go to the Power BI Admin portal

1. In Tenant settings, find 'Developer settings'. Open the 'Service principals can use Fabric APIs'. Enable it. Select 'Specific security groups' and type the name of the recently created security group 'masthead-powerbi-security-group'. Click Apply button.

1. In Tenant settings, find 'Admin API settings'

1. Enable 'Service principals can access read-only admin APIs', specify security group 'masthead-powerbi-security-group' and click Apply.

1. Enable 'Enhance admin APIs responses with detailed metadata', specify security group 'masthead-powerbi-security-group' and click Apply.

1. Enable 'Enhance admin APIs responses with DAX and mashup expressions', specify security group 'masthead-powerbi-security-group' and click Apply.

NOTE: The changes take up to 15 mins to be applied. After that you can use the tenant id, client id and client secret to set up the integration in Masthead.

Step 4. Configure Power BI integration in Masthead

1. Login to Masthead and navigate to Integrations menu.

2. Click Connect on Power BI.

3. Specify 'Tenant ID', 'Client ID' and 'Client Secret'. Click Save.