Connection test fails when using Microsoft Purview to scan my Microsoft Fabric environment

Question

I am trying to use my tables in OneLake as a source of data for Purview.

I setup the fabric connection as follows and then test the connection which fails

When looking at the details I get the following error: Exception when processing request: ErrorCode:(3871) UserErrorDataScanPowerBIBasicMetadataFailure.

I have searched forums and this problem is common but in this forum they solved it offline without documenting the answer.

The API configuration in Power Admin should be correct:

I can connect to other ADLS containers but I specifically was hoping to scan tables and files in my lakehouse.

This is becoming a block now as I have been unable to progress this for a few days.

Answer 1

@Simon Tuson - Thanks for the question and using MS Q&A platfrom.

Regarding the error you're experiencing, ErrorCode:(3871) UserErrorDataScanPowerBIBasicMetadataFailure, it's likely due to an issue with the metadata scanning of your Power BI items in the Fabric tenant. This error suggests that there's a problem with the basic metadata of your Power BI items, which is preventing the scanning process from completing successfully.

To troubleshoot this issue, I recommend reviewing the setup steps again to ensure that everything is correct. Specifically, double-check the following:

• Your Fabric and Microsoft Purview accounts are in the same tenant.
• The Fabric tenant ID is entered correctly during registration.
• The Fabric Metadata model is up to date by enabling metadata scanning.
• The Microsoft Purview Account Network is set to public access in the Azure portal.
• The Fabric tenant is configured to allow public network in the Fabric tenant Admin Portal.
• A security group is created in Microsoft Entra tenant, and the Microsoft Purview account MSI or service principal is a member of the new security group.
• The "Allow service principals to use read-only admin APIs" option is enabled for the new security group in the Fabric Tenant Admin portal.

In case, if you are experiencing the same issue after reviewing the setup - please do share the below information to help you troubleshoot the issue and provide additional guidance.

• Purview Account name:
• Location:
• Confirmed that both Purview and Fabric are in the same tenant
• From Power BI admin portal: enabled "Allow service principle to use read-only Power BI admin APIs(Preview)"
• After you update the Admin API settings on your power bi tenant, wait around 15 minutes before registering a scan and test connection.

For more details, refer to Connect to and manage a Power BI tenant in Microsoft Purview (Same Tenant).

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.