Versions Compared

Old Version 18

changes.mady.by.user Dean Nguyen

Saved on

compared with

New Version 19

changes.mady.by.user Dean Nguyen

Saved on

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.

Scope

Included

Comments

Metadata

Status
colourGreen
titleYES

 See limitations below

Lineage

Status
colourGreen
titleYES

 

Usage

Status
colourGreen
titleYES

Sensitive Data Scanner

Status
titleN/A

 

Info

Known Power BI limitations:

  • Power BI API is currently rate limited. This may impact extracts where you have 200+ workspaces or groups. Some Power BI reports may fail to extract correctly and may their details may not be profiled.

  • Power BI datasets using large dataset storage format cannot be profiled

  • Power BI reports created in web browser (not uploaded from desktop) cannot be profiled for detailed lineage

  • Power BI dashboards in Apps are not able to be linked to their Power BI dashboard

Known KADA Power BI integration limitations (to be resolved in upcoming releases)

  • Power BI currently only supports lineage to Snowflake, SQL Server and Oracle

  • Power BI reports that use inbuilt fields cannot be profiled for detailed lineage

  • Power BI reports created in web browser missing dataset lineage

...

  • 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

  • [Required for Power BI detailed lineage] 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

...

Info

This step is performed by the Power BI Admin

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

...