topic Re: Encountered operating system error 5(Access is denied.) while attempting to read physical metada in Data Engineering

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

rubayatyasmin — Tue, 18 Mar 2025 23:43:07 GMT

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:

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

nilendraFabric — Wed, 19 Mar 2025 07:46:39 GMT

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

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

rubayatyasmin — Wed, 19 Mar 2025 11:53:25 GMT

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.

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

v-veshwara-msft — Thu, 20 Mar 2025 09:54:19 GMT

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.

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

rubayatyasmin — Fri, 21 Mar 2025 13:14:16 GMT

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

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

v-veshwara-msft — Mon, 24 Mar 2025 05:52:15 GMT

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.

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

aflath — Mon, 07 Apr 2025 16:20:52 GMT

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

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

CeeVee33 — Fri, 11 Apr 2025 02:13:27 GMT

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.

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

rubayatyasmin — Fri, 11 Apr 2025 13:32:49 GMT

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.

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

CeeVee33 — Mon, 14 Apr 2025 00:39:51 GMT

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

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

elanghorst — Wed, 03 Dec 2025 15:08:46 GMT

Hi,

Re: Fabric Lakehouse SQL endpoint access to physic... - Microsoft Fabric Community

this was the smoking gun for us.

An adminaccount was deprecated, but that admin had created our lakehouse.

When you go to settings of a Fabric Item you can click on 'take over'
After that worked again