Microsoft Power BI

Follow these steps to connect your Microsoft Power BI instance to Select Star.

Before you start

To connect Microsoft Power BI to Select Star, you will need...

• Admin access to Microsoft Entra ID (formerly Azure AD)

• Admin access to Microsoft Fabric (formerly Power BI Admin Portal)

Complete the following steps to enable metadata, lineage, and popularity of your Microsoft Power BI in Select Star.

1. Create an Azure app

2. Create a security group in Microsoft Entra ID

3. Enable the Power BI service admin settings

4. Add Azure app to your workspace

5. Connect Power BI API to Select Star

1. Create an Azure app

1. Open the Azure Portal and sign in.

2. Search for App registrations, and select it.

3. Click New registration.

4. Fill in the required information:

• Name: type "Select Star"

• Supported account types: leave the default value

  • "Accounts in this organizational directory only (xxxxxxxxx only - Single tenant)"

• Redirect URI - leave empty

5. Click Register.

Screenshot shows the filled registration form.

1. From the Overview page, copy the Application (client) ID and Directory (tenant) ID, and securely store them for next steps.

Screenshot shows where to obtain the Client ID, and Tenant ID

7. Click the Certificates & secrets from the left menu.

8. Under Client secrets, click + New client secret.

Screenshot shows the new client secret button in the Certificates and secrets tab.

In the Add a client secret window, enter a description, select an expiry time, and click Add.

• Sample description: Secret used to connect Select Star to Microsoft Power BI

Copy the client secret Value and securely store it for the next steps.

Screenshot shows where to obtain the Client secret value in the Certificates and secrets tab

2. Create a security group in Microsoft Entra ID

1. Open the Azure Portal and sign in.

2. Search for Microsoft Entra ID, and select it.

3. Click the Groups, under Manage section.

Screenshot shows the Groups tab for an app in the Azure Active Directory section.

4. Click New group.

5. Fill in the required information:

• Group type - select "Security"

• Name - type "Power BI - API Access"

• Group description - enter any description or leave empty

  • Sample description: Security group to grant API access

6. Click "No members selected" to open a drawer. Search for Select Star user and select it. Click the Select button to confirm.

7. Click Create.

Screenshot shows the filled in form, and selected memeber for security group.

By the end of these steps, you have registered an application with Microsoft Entra ID and created a Security Group with the appropriate member.

3. Enable the Power BI service admin settings

1. Open Power BI admin portal and sign in.

2. Click Tenant Settings under the Admin Portal.

• You must have admin access to Microsoft Fabric to configure these settings

3. Under Developer settings:

• Expand Service principals can call Fabric public APIs

  • Set this to Enabled.

  • Add your security group you created in Step 2, under Specific security groups.

  • Click Apply.

4. Repeat the process for the subsections under the Admin API settings section.

• Open the section, Set Enabled, and add the security group you created in Step 2. Click Apply.

You must complete the steps for the following sections under Admin API settings:

• Service principals can access read-only admin APIs

• Enhance admin APIs responses with detailed metadata

• Enhance admin APIs responses with DAX and mashup expressions

The screenshot shows the highleted sections, needed to enabled for Microsoft Power BI Integration

4. Add Azure app to your workspace

1. Open Power BI and sign in.

2. Search for the workspace you want to enable access for, and from the three-button menu, select Workspace access.

Screenshot shows the "Workspace access" button in workspace list.

3. Click + Add people or groups

4. Search for the app you created in step 1, i.e, Select Star, and select it. Set the permissions to Contributor.

5. Click Add, and close the drawer.

6. Repeat the above steps for all workspaces you want to be added to Select Star.

Important! If you have any Power BI reports using Semantic Models from other workspaces, please make sure to add the Azure App you created in Step 1 as a Contributor to all those workspaces. This is required to ingest the reports' metadata and generate the column-level lineage.

5. Connect Power BI API to Select Star

1. Go to the Select Star Settings. Click Data in the sidebar, then + Add to create a new Data Source.

Screenshot shows the "Add Data source" tab for PowerBI in Select Star.

2. Fill in the required information:

• Client ID: Application (client) ID of Azure App from step 1.6 above.

• Client Secret: Client secret value of Azure App from step 1.8 above.

• Tenant ID: Directory (tenant) ID of Azure App from step 1.6 above.