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 - I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer .

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

Solution: The issue has been resolved.

The issue was I had not enabled the setting for enhancing dax and mashup expressions in api response, this needs to be enabled.

This documented here Connect to and manage a Power BI tenant same tenant | Microsoft Learn but I missed it as it was merged with another setting. :-(

Double check that the security group has members to..

If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.

If you have any other questions, please let me know. Thank you again for your time and patience throughout this issue.

---

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

Answer 2

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