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
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.
From the Overview page, copy the Application (client) ID and Directory (tenant) ID, and securely store them for next steps.
7. Click the Certificates & secrets from the left menu.
8. Under Client secrets, click + New client secret.
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.
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.
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.
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
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.
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.
2. Fill in the required information:
Last updated
Was this helpful?