PowerBI
Follow these steps to connect your PowerBI instance to Select Star.
Last updated
Was this helpful?
Follow these steps to connect your PowerBI instance to Select Star.
Last updated
Was this helpful?
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.
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. 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.
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
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 Star as member and select Select Star entry.
Permission - select "Contributor"
4. Click Add button to add.
5. Click Close button to confirm.
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:
1. Open and sign in.
1. Open and sign in using a Global administrator account for the directory.
1. Open and sign in.
1. Open and sign in.
Client ID: Application ID of Azure AD. You'll see this after completing of the instructions.
Client Secret: Client secret of Application in Azure AD. You'll see this after completing of the instructions.
Tenant ID: Identifier of tenant of organization in Azure Active AD. You'll see this after completing of the instructions.
