Forum Discussion
Encountered operating system error 5(Access is denied.) while attempting to read physical metadata.
Thanks for the information. I checked the known issues already. My problem solved after reauthenticating all the connections.
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.
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.
Thanks for the information. I checked the known issues already. My problem solved after reauthenticating all the connections.
Yea. I had to reauthenticate as well. Basically went into the Data Source setting, and re-logged in.
Hi rubayatyasmin ,
Thanks for the update.
Glad to hear that reauthenticating the connections resolved the issue.Also, if this solution worked for you, please consider accepting the reply as a solution to help others facing a similar issue. If you found my response helpful as well, you may consider marking it as a solution too.
Thank you.
Hi rubayatyasmin , I'm having same issue. The LH and WH are on service account which may have had paswwrod change. Can you advise where did you re-authenticate. I do not see any place which asks me to sign in.
aflath Any help from you would also be great.
In my case, when I tried to use PBI service it asked me to log in several times. Apart from LH, WH I had data flows g2 and semantic models. I reauthincated those items as well.
Best thing would be log out and log in again. Give it some time then try again. I faced this 2-3 days. After that reauthenticating items worked for me.
rubayatyasmin thank you for the reposnse.
It didnt ask me as many times. But 2 times. I signed in, and gave it 15 mins to sync. Then it works for me.
Also, I did this on office network. Error was thrown on VPN. Though Fabric is cloud-based, I will test from VPN again and possibly a port somewhere on VPN needs to be opened. I'll jump on to Fiddler, if it comes to it.
Thanks for the help.
