Forum Discussion

istock-rpm's avatar
istock-rpm
Frequent Visitor
1 year ago
Solved

Encountered operating system error 5(Access is denied.) while attempting to read physical metadata.

I'm getting the following error

Encountered operating system error 5(Access is denied.) while attempting to read physical metadata.

 

Lastest search:  Known issue - Sync for data warehouse and SQL analytics endpoint fail in West Europe - Microsoft Fabric | Microsoft Learn

This is suppose to be fixed.  There is workaroud on the page: "Try to retry the sync operation to temporarily mitigate the scenario."  I have no idea what this means or what to do.

  • istock-rpm's avatar
    istock-rpm
    1 year ago

    The ownership of DBs (Lakehouse, Data Warehouse) was a service principal.  A change of ownership to a user principal with admin permission resolved the issue.

5 Replies

  • istock-rpm's avatar
    istock-rpm
    Frequent Visitor

    Also, my workspace has been running fine without issues until 7/8/2025.

    • istock-rpm's avatar
      istock-rpm
      Frequent Visitor

      The ownership of DBs (Lakehouse, Data Warehouse) was a service principal.  A change of ownership to a user principal with admin permission resolved the issue.

  • istock-rpm's avatar
    istock-rpm
    Frequent Visitor

    Additional Info:  A service principal is the owner of all DB SKUs (Lakehouse, Data Warehouse).

  • Hi
    Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.

  • dzav's avatar
    dzav
    Icon for Advocate III rankAdvocate III

    We're experiencing this today in East US for a lakehouse and warehouse. Other lakehouses and warehouses in the same workspace and other workspaces are not affected. Simple SELECT TOP 1000 queries take 20+ minutes and return this same error (Encountered operating system error 5(Access is denied.) while attempting to read physical metadata.) According to Microsoft Fabric service status only Asia Pacific is degraded.