Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Scroll ignore
scroll-viewporttrue
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-htmltrue
scroll-epubtrue

Open in new tab

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 check that that add the following permissions

    • Microsoft.Graph

    -
      • User.Read permission

    has been added

...

    • Power BI

      • Capacity.Read.All

      • Dashboard.Read.All

      • Dataset.Read.All

      • Report.Read.All

      • Workspace.Read.All

Image Added

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

...

  • Next to your new Source, click on the Run manual load icon

  • Confirm how your want the source to be loaded

    Image RemovedImage Added
  • 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

    Image RemovedImage Added
Info

A manual source load will also require a manual run of

  • DAILY

  • GATHER_METRICS_AND_STATS

To load all metrics and indexes with the manually loaded metadata. These can be found in the Batch Manager page

...