Masthead Data
  • Introduction
    • What is Masthead Data?
    • Data Anomaly Detection
    • Pipeline and Model Observability
    • Data Quality
    • Metadata management: Column-level lineage and Data Dictionary
  • GET STARTED
    • Quickstart
  • COST INSIGHTS
    • Pipeline Costs
    • Storage Costs
  • INTEGRATIONS
    • Slack
    • Looker
    • PagerDuty
    • Power BI
  • Resources
    • Release Notes
    • Support
Powered by GitBook
On this page
  1. INTEGRATIONS

Power BI

Power BI integration setup details

Last updated 1 month ago

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

1

Create a service principal app in Azure

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

  1. Click 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 Manage menu open the drop down and click on Certificates & secretes. Click New client secret.

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

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

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.

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

  1. Navigate to the Members menu and click Add members

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

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 and enable it. Select Specific security groups and type the name of the recently created security group masthead-powerbi-security-group. Click Apply.

  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.

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.

5

Power BI integration complete.