Connect to your Microsoft Fabric tenant in the same tenant as Microsoft Purview (Preview)
Article
Important
Scanning a Microsoft Fabric tenant will bring in metadata and lineage from Fabric items including Power BI. The experience of registering a Fabric tenant and setting up a scan is similar to Power BI tenant and shared among all Fabric items. The scanning of Fabric items other than Power BI is currently in preview. The Supplemental Terms of Use for Microsoft Azure Previews include additional legal terms that apply to Azure features that are in beta, in preview, or otherwise not yet released into general availability.
This article outlines how to register a Microsoft Fabric tenant that's in the same tenant as your Microsoft Purview resource, and how to authenticate and interact with the Fabric source in Microsoft Purview. For more information about Microsoft Purview in general, read the introductory article.
Note
Starting from December 13th 2023, scanning Fabric tenants registered with the Fabric data source in Microsoft Purview will capture metadata and lineage from Fabric items including Power BI. The new feature will become available in all Microsoft Purview public cloud regions in the following days.
The supported scenarios above apply for non-Power BI items in Fabric. See the Power BI documentation for supported scenarios applicable for Power BI items.
Known limitations
Currently for all Fabric items besides Power BI, only item level metadata and lineage will be scanned, scanning metadata and lineage of sub level items like Lakehouse tables or files isn't supported.
Microsoft Purview Managed Identity has get/list access to secrets.
Review your credential to validate:
Client ID matches Application (Client) ID of the app registration.
Username includes the user principal name such as johndoe@contoso.com.
If Delegated Authentication is used, validate Fabric admin user settings to make sure:
User is assigned to Fabric Administrator role.
If user is recently created, sign in with the user at least once to make sure password is reset successfully and user can successfully initiate the session.
There's no MFA or Conditional Access Policies are enforced on the user.
Validate App registration settings to make sure:
App registration exists in your Microsoft Entra tenant.
If service principal is used, under API permissions, the following delegated permissions are assigned with read for the following APIs:
Microsoft Graph openid
Microsoft Graph User.Read
If delegated authentication is used, under API permissions, the following delegated permissions and grant admin consent for the tenant is set up with read for the following APIs:
Power BI Service Tenant.Read.All
Microsoft Graph openid
Microsoft Graph User.Read
Under Authentication, Allow public client flows is enabled.
In Microsoft Entra tenant, create a security group.
This section describes how to register a Fabric tenant in Microsoft Purview for same-tenant scenario.
Select the Data Map on the left navigation.
Then select Register.
Select Fabric as your data source.
Give your Fabric instance a friendly name and select a collection.
The name must be between 3-63 characters long and must contain only letters, numbers, underscores, and hyphens. Spaces aren't allowed.
By default, the system will find the Fabric tenant that exists in the same Microsoft Entra tenant.
Authentication to scan
To be able to scan your Microsoft Fabric tenant and review its metadata, you'll first need to create a way to authenticate with the Fabric tenant, and then give Microsoft Purview the authentication information.
Authenticate to Fabric tenant
In Microsoft Entra tenant, where Fabric tenant is located:
In the Azure portal, search for Microsoft Entra ID.
You can skip this step if you already have a security group you want to use.
Select Security as the Group Type.
Add any relevant users to the security group:
If you're using Managed Identity as authentication method, add your Microsoft Purview managed identity to this security group. Select Members, then select + Add members.
If you're using delegated authentication or service principal as authentication method, add your service principal to this security group. Select Members, then select + Add members.
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.
You need to be a Fabric Admin to see the tenant settings page.
Select Admin API settings > Allow service principals to use read-only admin APIs.
Select Specific security groups.
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 Fabric datasets as part of its scans.
Important
After you update the Admin API settings on your Fabric 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 admin APIs, you also allow it to access the metadata (e.g. dashboard and report names, owners, descriptions, etc.) for all of your Fabric artifacts in this tenant. Once the metadata has been pulled into the Microsoft Purview, Microsoft Purview's permissions, not Fabric 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.
Configure credentials for scans in Microsoft Purview
From Microsoft Entra dashboard, select newly created application and then select App registration. From API Permissions, assign the application the following delegated permissions:
Microsoft Graph openid
Microsoft Graph User.Read
Under Advanced settings, enable Allow Public client flows.
Under Certificates & secrets, create a new secret and save it securely for next steps.
In Azure portal, navigate to your Azure key vault.
Select Settings > Secrets and select + Generate/Import.
Enter a name for the secret and for Value, type the newly created secret for the App registration. Select Create to complete.
Now that your secret is created, in Microsoft Purview, go to the Credentials page under Management.
Tip
Alternatively, you can create a new credential during the scanning process.
Create your new Credential by selecting + New.
Provide required parameters:
Name: Provide a unique name for credential
Authentication method: Service principal
Tenant ID: Your Fabric tenant ID
Client ID: Use Service Principal Client ID (App ID) you created earlier
Key Vault Connection: the Microsoft Purview connection to the Key Vault where you created your secret earlier.
Secret name: the name of the secret you created earlier.
Once all the details have been filled in, select Create.
Delegated authentication
Create a user account in Microsoft Entra tenant and assign the user to Microsoft Entra role, Fabric Administrator. Take note of username and sign in to change the password.
Navigate to your Azure key vault.
Select Settings > Secrets and select + Generate/Import.
Enter a name for the secret and for Value, type the newly created password for the Microsoft Entra user. Select Create to complete.
Create an App Registration in your Microsoft Entra tenant. Provide a web URL in the Redirect URI.
Take note of Client ID(App ID).
From Microsoft Entra dashboard, select newly created application and then select API permissions. Assign the application the following delegated permissions, and grant admin consent for the tenant:
Fabric Service Tenant.Read.All
Microsoft Graph openid
Microsoft Graph User.Read
Under Advanced settings, enable Allow Public client flows.
Next, in Microsoft Purview, go to the Credentials page under Management to create a new credential.
Tip
Alternatively, you can create a new credential during the scanning process.
Create your new Credential by selecting + New.
Provide required parameters:
Name: Provide a unique name for credential
Authentication method: Delegated auth
Client ID: Use Service Principal Client ID (App ID) you created earlier
User name: Provide the username of Fabric Administrator you created earlier
Key Vault Connection: the Microsoft Purview connection to the Key Vault where you created your secret earlier.
Secret name: the name of the secret you created earlier.
Once all the details have been filled in, select Create.
Create scan
In the Microsoft Purview Studio, navigate to the Data map in the left menu.
Navigate to Sources.
Select the registered Fabric source.
Select + New scan.
Give your scan a name.
Select either your managed identity credential, or the credential you created for your service principal or delegated authentication.
Select Test Connection before continuing to next steps. If Test Connection failed, select View Report to see the detailed status and troubleshoot the problem.
Access - Failed status means the user authentication failed. Scans using managed identity will always pass because no user authentication required. If using service principal or delegated authentication, make sure your Key Vault credential was correctly set up and that Microsoft Purview has access to the key vault.
Assets (+ lineage) - Failed status means the Microsoft Purview - Fabric authorization has failed. Make sure the Microsoft Purview managed identity is added to the security group associated in Fabric admin portal.
Detailed metadata (Enhanced) - Failed status means the Fabric admin portal is disabled for the following setting - Enhance admin APIs responses with detailed metadata
Tip
For more troubleshooting, see the deployment checklist to make sure you've covered every step in your scenario.
Set up a scan trigger. Your options are Recurring, and Once.
On Review new scan, select Save and run to launch your scan.
View your scans and scan runs
To view existing scans:
Go to the Microsoft Purview portal. On the left pane, select Data map.
Select the data source. You can view a list of existing scans on that data source under Recent scans, or you can view all scans on the Scans tab.
Select the scan that has results you want to view. The pane shows you all the previous scan runs, along with the status and metrics for each scan run.
As a Fabric analytics engineer associate, you should have subject matter expertise in designing, creating, and deploying enterprise-scale data analytics solutions.