PowerBI
Follow these steps to connect your PowerBI instance to Select Star.
Before you start
Please make sure your datasets are refreshed frequently (either via scheduled refresh or on-demand).
To connect PowerBI to Select Star, you will need...
Access to the Global administrator account for the Azure Active Directory.
Access to Power BI admin for the PowerBI.
Select Star requires only minimal metadata access to PowerBI. Here are the list of access Select Star will request for:
"allow service principals to use Power BI APIs"
"allow service principals to use read-only Power BI admin APIs"
"Contributor" role in each ingested workspace
1. Create an Azure AD app
1. Open Azure Portal and sign in.
2. Search for App registrations and select App registrations link.
3. Click New registration.
4. Fill form in the required information:
Name - type "Select Star"
Supported account types - Select "Accounts in this organizational directory only"
(Optional) Redirect URI - leave empty
5. Click Register.
6. After submitting the form, the Application ID is available from the Overview tab. Copy and save the Application ID for later use.
7. Click the Certificates & secrets tab.
8. Click the New client secret button.
In the Add a client secret window, enter any description, specify when you want the client secret to expire, and click Add.
Copy and save the Client secret value.
2. Create an Azure AD security group
1. Open Azure Portal and sign in using a Global administrator account for the directory.
2. Search for Azure Active Directory and select Azure Active Directory link.
3. The Tenant ID is available from the Overview tab. Copy and save the Tenant ID for later use.
4. Click the Groups tab.
5. Click the New group button.
6. Fill form in the required information:
Group type - select "Security"
Name - type "PowerBI-API access"
Group description - enter any description or leave empty
7. Select "No members selected" to open a drawer. Search for Select Star and select Select Star entry. Click the Select button to confirm.
8. Click Create.
3. Enable the Power BI service admin settings
1. Open Power BI admin portal and sign in.
2. Log into the Power BI admin portal. You need to be a Power BI admin to see the tenant settings page.
3. Ensure that Tenant settings tab are open.
4. Search for the subsection "Allow service principals to use Power BI APIs" in "Developer settings" section and open it. Select "Enabled" and add the security group you created "PowerBI-API access" in Azure AD. Click Apply.
5. Repeat process for all subsection in "Admin API settings" section. Open the section, Select "Enabled" and add the security group you created "PowerBI-API access" in Azure AD. Click Apply. You must complete the step for following sections:
Allow service principals to use read-only admin APIs
Enhance admin APIs responses with detailed metadata
Enhance admin APIs responses with DAX and mashup expressions
Download Reports
4. Add Azure AD app to your workspace
1. Open Power BI and sign in.
2. Search to the workspace you want to enable access for, and from the More menu, select Workspace access.
3. Fill form in the required information:
Search for
Select Staras member and select Select Star entry.Permission - select "Contributor"
4. Click Add button to add.
5. Click Close button to confirm.
5. Connect PowerBI 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 form in the required information:
Client ID: Application ID of Azure AD. You'll see this after completing step 1.6 of the instructions.
Client Secret: Client secret of Application in Azure AD. You'll see this after completing step 1.8 of the instructions.
Tenant ID: Identifier of tenant of organization in Azure Active AD. You'll see this after completing step 2.3 of the instructions.
Last updated