Connect to and manage a Power BI tenant in Microsoft Purview (cross-tenant)

This article outlines how to register a Power BI tenant in a cross-tenant scenario, and how to authenticate and interact with the tenant in Microsoft Purview. If you're unfamiliar with the service, see Learn about Microsoft Purview.

Supported capabilities

* Power BI items in a Microsoft Fabric tenant are available using live view.

When scanning Power BI source, Microsoft Purview supports:

• Extracting technical metadata including:

  • Workspaces
  • Dashboards
  • Reports
  • Datasets including the tables and columns
  • Dataflows
  • Datamarts

• Fetching static lineage on assets relationships among above Power BI artifacts and external data source assets. Learn more from Power BI lineage.

Supported scenarios for Power BI scans

Known limitations

• If Power BI tenant is protected behind a private endpoint, standard or kubernetes supported self-hosted runtimes are the only options to scan.
• For the cross-tenant scenario, delegated authentication and service principal are the only supported authentication options for scanning.
• If the Power BI dataset schema isn't shown after the scan, it's due to one of the current limitations with the Power BI metadata scanner.
• Empty workspaces are skipped.

Prerequisites

Before you start, make sure you have the following:

• An Azure account with an active subscription. Create an account for free.

• An active Microsoft Purview account.

Register the Power BI tenant

1. From the options on the left, select Data Map.

2. Select Register, and then select Fabric as your data source. It includes Power BI sources and assets.

   

3. Give your data source a friendly name. The name must be 3 to 63 characters long, and must contain only letters, numbers, underscores, and hyphens. Spaces aren't allowed.

4. Edit the Tenant ID field, to replace with the tenant for the cross-tenant Power BI that you want to register and scan. By default, Microsoft Purview's tenant ID is populated.

   

5. Select Register.

Authenticate to Power BI tenant

In Microsoft Entra tenant, where Power BI tenant is located:

1. In the Azure portal, search for Microsoft Entra ID.

2. Create a new security group in your Microsoft Entra ID, by following Create a basic group and add members using Microsoft Entra ID.

   Tip

   You can skip this step if you already have a security group you want to use.

3. Select Security as the Group Type.

   

4. Select Members, then select + Add members.

5. Search for your Microsoft Purview managed identity or service principal and select it.

   

   You should see a success notification showing you that it was added.

   

Associate the security group with Power BI tenant

1. Log into the Power BI admin portal.

2. Select the Tenant settings page.

   Important

   You need to be a Power BI Admin to see the tenant settings page.

3. Select Admin API settings > Allow service principals to use read-only Power BI admin APIs (Preview).

4. Select Specific security groups.

   

5. Select Admin API settings > Enhance admin APIs responses with detailed metadata and Enhance admin APIs responses with DAX and mashup expressions > Enable the toggle to allow Microsoft Purview Data Map automatically discover the detailed metadata of Power BI datasets as part of its scans.

   Important

   After you update the Admin API settings on your power bi tenant, wait around 15 minutes before registering a scan and test connection.

   

   Caution

   When you allow the security group you created (that has your Microsoft Purview managed identity as a member) to use read-only Power BI admin APIs, you also allow it to access the metadata (e.g. dashboard and report names, owners, descriptions, etc.) for all of your Power BI artifacts in this tenant. Once the metadata has been pulled into the Microsoft Purview, Microsoft Purview's permissions, not Power BI permissions, determine who can see that metadata.

   Note

   You can remove the security group from your developer settings, but the metadata previously extracted won't be removed from the Microsoft Purview account. You can delete it separately, if you wish.

Scan cross-tenant Power BI

Delegated authentication and service principals are the only supported options for cross-tenant scanning. You can scan using either:

• The Azure integration runtime
• A self-hosted integration runtime

Create scan for cross-tenant using Azure IR with delegated authentication

To create and run a new scan by using the Azure runtime, perform the following steps:

1. Create a user account in the Microsoft Entra tenant where the Power BI tenant is located, and assign the user to this role: Fabric Administrator. Take note of the username and sign in to change the password.

2. Assign the proper Power BI license to the user.

3. Go to the instance of Azure Key Vault in the tenant where Microsoft Purview is created.

4. Select Settings > Secrets, and then select + Generate/Import.

   

5. Enter a name for the secret. For Value, type the newly created password for the Microsoft Entra user. Select Create to complete.

   

6. If your key vault isn't connected to Microsoft Purview yet, you need to create a new key vault connection.

7. Create an app registration in your Microsoft Entra tenant where Power BI is located. Provide a web URL in the Redirect URI.

   

8. Take note of the client ID (app ID).

   

9. From the Microsoft Entra dashboard, select the newly created application, and then select App permissions. Assign the application the following delegated permissions, and grant admin consent for the tenant:

   • Power BI Service Tenant.Read.All
   • Microsoft Graph openid
   • Microsoft Graph User.Read

   

10. From the Microsoft Entra dashboard, select the newly created application, and then select Authentication. Under Supported account types, select Accounts in any organizational directory (Any Microsoft Entra directory - Multitenant).

    

11. Under Implicit grant and hybrid flows, select ID tokens (used for implicit and hybrid flows).

    

12. Under Advanced settings, enable Allow Public client flows.

13. In the Microsoft Purview Studio, go to the Data map in the left menu. Go to Sources.

14. Select the registered Power BI source from cross-tenant.

15. Select + New scan.

16. Give your scan a name. Then select the option to include or exclude the personal workspaces.

    Note

    If you switch the configuration of a scan to include or exclude a personal workspace, you trigger a full scan of the Power BI source.

17. Select Azure AutoResolveIntegrationRuntime from the dropdown list.

    

18. For the Credential, select Delegated authentication, and then select + New to create a new credential.

19. Create a new credential and provide the following required parameters:

    • Name: Provide a unique name for the credential.

    • Client ID: Use the service principal client ID (app ID) that you created earlier.

    • User name: Provide the username of the Fabric administrator that you created earlier.

    • Password: Select the appropriate Key Vault connection, and the Secret name where the Power BI account password was saved earlier.

    

20. Select Test connection before continuing to the next steps.

    

    If the test fails, select View Report to see the detailed status and troubleshoot the problem:

    1. Access - Failed status means that the user authentication failed. Validate if the username and password are correct. Review if the credential contains the correct client (app) ID from the app registration.
    2. Assets (+ lineage) - Failed status means that the authorization between Microsoft Purview and Power BI has failed. Make sure that the user is added to the Fabric Administrator role (former Power BI Administrator role), and has the proper Power BI license assigned.
    3. Detailed metadata (Enhanced) - Failed status means that the Power BI admin portal is disabled for the following setting: Enhance admin APIs responses with detailed metadata.

21. Set up a scan trigger. Your options are Recurring or Once.

    

22. On Review new scan, select Save and run to launch your scan.

    

Create scan for cross-tenant using self-hosted IR with service principal

To create and run a new scan by using the self-hosted integration runtime, perform the following steps:

1. Create an app registration in your Microsoft Entra tenant where Power BI is located. Provide a web URL in the Redirect URI.

   

2. Take note of the client ID (app ID).

   

3. From the Microsoft Entra dashboard, select the newly created application, and then select App permissions. Assign the application the following delegated permissions:

   • Microsoft Graph openid
   • Microsoft Graph User.Read

   

4. From the Microsoft Entra dashboard, select the newly created application, and then select Authentication. Under Supported account types, select Accounts in any organizational directory (Any Microsoft Entra directory - Multitenant).

   

5. Under Implicit grant and hybrid flows, select ID tokens (used for implicit and hybrid flows).

   

6. Under Advanced settings, enable Allow Public client flows.

7. In the tenant where Microsoft Purview is created go to the instance of Azure Key Vault.

8. Select Settings > Secrets, and then select + Generate/Import.

   

9. Enter a name for the secret. For Value, type the newly created secret for the App registration. Select Create to complete.

10. Under Certificates & secrets, create a new secret and save it securely for next steps.

11. In Azure portal, navigate to your Azure key vault.

12. Select Settings > Secrets and select + Generate/Import.

    

13. Enter a name for the secret and for Value, type the newly created secret for the App registration. Select Create to complete.

    

14. If your key vault isn't connected to Microsoft Purview yet, you need to create a new key vault connection.

15. In the Microsoft Purview Studio, go to the Data map in the left menu. Go to Sources.

16. Select the registered Power BI source from cross-tenant.

17. Select + New scan.

18. Give your scan a name. Then select the option to include or exclude the personal workspaces.

    Note

    If you switch the configuration of a scan to include or exclude a personal workspace, you trigger a full scan of the Power BI source.

19. Select your self-hosted integration runtime from the drop-down list.

20. For the Credential, select Service Principal, and then select + New to create a new credential.

21. Create a new credential and provide the following required parameters:

    • Name: Provide a unique name for credential
    • Authentication method: Service principal
    • Tenant ID: Your Power BI tenant ID
    • Client ID: Use Service Principal Client ID (App ID) you created earlier

    

22. Select Test connection before continuing to the next steps.

    If the test fails, select View Report to see the detailed status and troubleshoot the problem:

    1. Access - Failed status means that the user authentication failed. Validate if the App ID and secret are correct. Review if the credential contains the correct client (app) ID from the app registration.
    2. Assets (+ lineage) - Failed status means that the authorization between Microsoft Purview and Power BI has failed. Make sure that the user is added to the Fabric Administrator role (former Power BI Administrator role), and has the proper Power BI license assigned.
    3. Detailed metadata (Enhanced) - Failed status means that the Power BI admin portal is disabled for the following setting: Enhance admin APIs responses with detailed metadata.

23. Set up a scan trigger. Your options are Recurring or Once.

    

24. On Review new scan, select Save and run to launch your scan.

Deployment checklist

The deployment checklist is a summary of all the steps you'll need to take to set up a cross-tenant Power BI source. You can use it during setup or for troubleshooting, to confirm you've followed all the necessary steps to connect.

Next steps

Now that you've registered your source, see the following guides to learn more about Microsoft Purview and your data.

• Data estate insights in Microsoft Purview
• Lineage in Microsoft Purview
• Search data catalog