| Scroll ignore | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||
This page will walkthrough the setup of PowerBI in K.
...
Log in to your company’s Azure Portal and open the Azure Active Directory page
Select App Registration in the side panel and click New registration
Complete the registration form
Name: Enter a name for the integration e.g. KADA Power BI API Integration
Supported account types: Select Accounts in this organisation directory only
Redirect URL: Add Web / https://www.kada.ai
Click Register to complete the registration
Click on the newly created KADA Power BI API Integration App
Save the Application (client) ID and Directory (tenant) ID for use in a later step
Click on Endpoints and save the URL for OpenID Connect metadata document for use in a later step
Select Certificates & secrets in the side panel and click New client secret
Complete the new secret form and save the Secret Value for use in a later stope
Select API permissions in the side panel and add the following permissions
Microsoft.Graph
User.Read permission
Power BI
Capacity.Read.All
Dashboard.Read.All
Dataset.Read.All
Report.Read.All
WorkspaceGroups.Read.All
...
To add a permission, select Add a permission, followed by either the Microsoft Graph or Power BI Service option. Select Delegated Permission, select the permission(s) from the list and click Add Permissions.
...
Return to the Azure Portal and select Group
Find the AD Group that was created in step 1 and click Members
Select Add Members and add KADA Power BI API Integration to the group as a Service Principal
| Info |
|---|
Make sure you send the following information to the K Admin so that they can complete the next process.
|
...
Step 3) Add Service Principal to PowerBI Workspace(s)
| Info |
|---|
This step is performed by the Power BI Admin |
Your K instance will now have access to the majority of your Power BI assets. To profile and catalog items such as Pages within a Report, or if your datasource connections use parameters, please add the KADA Power BI API Integration (created in Step 2) as a Member to each Power BI workspace you want it to profile.
...
Step 4) Add PowerBI as a New Source
| Info |
|---|
This step is performed by the K Admin |
...
Next to your new Source, click on the Run manual load icon
Confirm how your want the source to be loaded
After the source load is triggered, a pop up bar will appear taking you to the Monitor tab in the Batch Manager page. This is the usual page you visit to view the progress of source loads
...