Data Quality Error Records to Fabric

Question

Data Quality Error Records to Fabric

Hilman 5

Hi,

I was followed below steps to connect Data quality(Microsoft Purview) to Fabric Onelake for failed records and the connection was successfull. But Failed to "Failed to save storage configuration" error

Refer to below documentation, To configure the storage and publish data quality error records:

https://learn.microsoft.com/en-us/purview/unified-catalog-data-quality-error-records

Configuration storage location

In Unified Catalog, go to Health management > Data quality.

Select a governance domain from the list to open its details page.

Select Manage, then select Settings.

Select Edit tab in the Settings page near to Configure storage title.

Select Storage Type: Fabric or Azure Data Lake Storage Gen2.

Enter the Location URL.

If the storage type is Fabric, then enter the Workspace ID and Lakehouse ID. Grant contributor accesses to Microsoft Purview Manage Service Identity (MSI) to your Fabric workspace.

Test the connection. User's image

Can anyone help me solve this error

1 answer

Your answer

Answer 1

Amira Bedhiafi 41,111 Volunteer Moderator

Hello !

Thank you for posting on Microsoft Learn Q&A.

It is either URL/IDs you entered aren’t in the exact OneLake format or the purview managed identity doesn’t have the right permissions.

You need to use the exact OneLake path format which is Fabric storage type.

Location URL example and the folder can be any you choose Files/… is required for lakehouse files abfss://<WORKSPACE_ID>@onelake.dfs.fabric.microsoft.com/<LAKEHOUSE_ID>/Files/DataQualityAuditExtracts

and paste the GUIDs for the workspace and the lakehouse item into the fields purview asks for and don’t paste names.

https://learn.microsoft.com/en-us/purview/unified-catalog-data-quality-error-records

In Fabric, giveMSI contributor on the workspace that contains the lakehouse.

In the Fabric admin portal enable also users can access data stored in OneLake with apps external to Fabric. Purview writes the error files as an external app and if this is off saving or scanning often fails. https://learn.microsoft.com/en-us/purview/unified-catalog-data-quality-troubleshooting

vpasquier 5 Reputation points

2025-11-13T12:00:34.97+00:00

Hello,
I am having the same issue. I have done exactly what you recommended (use the abfss URL copied-pasted from my Fabric lakehouse, enable access OneLake with external apps, Purview MSI has access to my workspace), but I still get the error message "Failed to save storage configuration". The test connection works fine.
Is there a way to get a more detailed error message to find the root cause?

Thank you!
Florian 0 Reputation points

2025-11-19T08:08:09.9733333+00:00

Hi, I am experiencing the same issue. I followed your recommended steps, but it still doesn't work.

Previously, there was no need to configure storage at the governance domain level and everything worked perfectly fine. I am also using the Fabric Location URL in the Unified Catalog settings under “Solution integrations” for self-serve analytics, and that setup works without any problems.

Could you please provide clear, step-by-step instructions? In my opinion, the documentation should also be updated accordingly.

Thank you and best regards
Neeruaarna Kesarla 0 Reputation points

2025-11-20T18:47:23.22+00:00

Hi, I am also facing the same issue but for adlsgen2, I have provided storage blob contributor role to purview MSI and test connection successful. still the issue exist. is there a way to resolve the issue?
Thanks.
Ahrendt, Florian 0 Reputation points

2025-11-27T11:02:29.1666667+00:00

It finally works on my side.

Over the last few days it looks like a change was rolled out, as the UI for the DQ settings has changed. I was able to get it working by using a URL in the following format:

https://onelake.dfs.fabric.microsoft.com/<Workspace_ID>/<Lakehouse_ID>/Files/PurviewMetadata

Important: When I included a "/" at the end of the URL (PurviewMetadata/), I could save the configuration, but the DQ scan did not run successfully or no error records were written to Fabric.

In the end, this doesn’t seem to have been a user error. Over the last few days I first received a “Failed to save configuration” error. After that, I was able to click Save, but the changes were not persisted. As of today, the configuration is finally being saved correctly.

Share via

Data Quality Error Records to Fabric

1 answer

Your answer