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

[rubayatyasmin]

Hi everyone,

I'm currently working with a Lakehouse and associated warehouses in my Fabric environment. I’m able to access the Lakehouse, and while it takes some time, I can preview data for tables. However, I’m running into an issue when trying to execute queries.

I’ve tried connecting to the SQL endpoint using the connection string and managed to connect via MS SQL Server Management Studio, but I’m unable to run any queries on the tables in the Lakehouse database.

Has anyone faced a similar issue or have any insights on how to run queries in the Lakehouse using the SQL endpoint?

Thanks in advance!

The error in WH:

[v-veshwara-msft]

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

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.

[rubayatyasmin · Accepted solution]

Thanks for the information. I checked the known issues already. My problem solved after reauthenticating all the connections. 

[CeeVee33]

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.

[rubayatyasmin]

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. 

[CeeVee33]

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

[aflath]

Yea.  I had to reauthenticate as well.  Basically went into the Data Source setting, and re-logged in. 

[v-veshwara-msft]

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.

[nilendraFabric]

Hello @rubayatyasmin 

I am facing similar issue with LH tables for last few days.

Newly added or updated tables may not yet be visible due to stale metadata

Try Trigger metadata synchronization manually, although it didn't worked for me.

Seems like something has been changes behind the scenes, worth raising the support ticket 

[rubayatyasmin]

Yeah, the tables are not new. Sync was perfect but from 2 days it started throwing errors. Raised a support ticket already at the time of posting. But as the matter needs to solve urgently thought of posting it here as well.