Page Comparison

This page will walkthrough the setup of PowerBI in K.

...

• Set Allow Service Principals to use read-only Power BI admin APIs to Enabled

  • Select Specific Security Groups

    • Add an AD group that is appropriate for managing this access. This is typically the Admin group for Power BI. If no appropriate group exists, contact your Azure AD admin to create a new security group.

    • Record this AD group for Step 2

  • Set Enhance admin API responses with detailed metadata to Enabled

    • Add the same AD group as the previous API Settings option

  • Set Enhance admin APIs responses with DAX and mashup expressions to Enabled

    • Add the same AD group as the previous API Settings option

• [Required for Power BI detailed lineage] Set Allow Service Principals to use Power BI APIs to Enabled

  • Select Specific Security Groups

    • Add the same AD group as the previous step

...

• 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 step

  Select API permissions in the side panel and add the following permissions

  Microsoft.Graph

• User.Read.All

Groups.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

...

[Required for Detailed Lineage] 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.

...