Power BI

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 app to access Power BI.

Lineage and details in data dictionary become available within 15-20 minutes after integration.

Create integration

There are 4 steps to integrate Masthead to Power BI:

Create a service principal app in Azure

1. Log in to the Azure Portal, and search for and select App Registrations.

   

2. Click New Registration.

   

3. Name registration masthead-powerbi-integration-app. Click Register.

   

4. After successful app registration, an Overview page displays app details. Copy the Application client ID and Directory tenant ID values to a secure location. You need these values later.

   

5. From the Manage menu, click Certificates & secrets. Click New client secret.

   

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

   

7. After the secret is successfully created, copy the value of the secret to a secure location; you need this value later.

   

Create Azure Entra ID security group

1. Open Microsoft Entra ID menu

   

2. Click Add -> Group button

   

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

   

4. Open the newly created group by navigating to Groups > All groups and clicking the masthead-powerbi-security-group group.

   

5. Navigate to the Members menu and click Add members

   

6. Search for masthead-powerbi-integration-app and select the checkbox to the left. Click Select.

   

Grant security group the access to Power BI APIs

1. Go to the Power BI Admin portal

   

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

   

3. In Tenant settings, find Admin API settings

   

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

   

5. Enable ‘Enhance admin APIs responses with detailed metadata’, specify security group ‘masthead-powerbi-security-group’ and click Apply.

   

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

   

Note

Note: The changes take up to 15 minutes to take effect. After that, you can use the tenant ID, client ID, and client secret to set up the integration in Masthead.

Configure Power BI integration in Masthead

Provide ‘Tenant ID’, ‘Client ID’ and ‘Client Secret’ via the Google Form.

The Masthead team sets up the integration and sends a notification once it’s complete.

The Power BI integration is now complete.