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

Hi rubayatyasmin ,

Thank you for reaching out to the Microsoft Fabric Community.

Appreciate your insights, nilendraFabric 

There have been some known issues reported related to this.

1. Table Sync Issues in West Europe Region.

Symptoms:

• Users may experience table latency issues when syncing tables, schema, or semantic models.

Workaround:

• Retry the sync operation as a temporary fix while Microsoft’s engineering team is working on a permanent solution.

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

2. Table Sync Failures Due to Unsupported Columns

Symptoms:

• If column mapping includes unsupported columns, the metadata sync may fail.

Workaround:

• Check for unsupported columns in the Lakehouse table and remove them before reattempting the sync.

3. SQL Analytics Endpoint Permissions Not Persisting After Schema Changes

Symptoms:

• Table permissions in the SQL analytics endpoint may not persist after a successful sync.

Workaround:

• If a schema change was made, reapply permissions on the SQL analytics endpoint after sync completion.

Known issue - SQL analytics endpoint tables lose permissions - Microsoft Fabric | Microsoft Learn

Additionally, When using SQL Server Management Studio (SSMS), queries may fail due to local permission restrictions.

Try running SSMS as an administrator to rule out local permission issues on your machine.

Thank you for your patience while the Microsoft Engineering team works on resolving these issues.

Since you've already raised a support ticket, hopefully, it will be addressed and resolved soon.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Vinay.