Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

60 Days of Data Days! Live and on-demand sessions, challenges, study groups and more! And it's all FREE!. Join now. Learn more

Reply
OlenaDumna
Frequent Visitor

Issue Accessing Lakehouse with SQL Analytics Endpoint 5(Access is denied.)

Hello, All

I am an administrator for a Fabric workspace, and I have encountered an issue when accessing our Lakehouse data.

When I access the Lakehouse with the type "Lakehouse" (standard view), I can see the data in the tables without any issues. However, when I access the Lakehouse with the type "SQL Analytics Endpoint,"
I receive the following error message:

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

 

I suspect this issue might be related to previous work done by a colleague who has since left our company.
As a result, I’m not sure if there are any permissions or configurations that were missed during the transition.


Could you please assist me in resolving this issue?
Any guidance on how to properly configure or troubleshoot this would be greatly appreciated.

Uptdate :
I have  takeover SQL Analytics Endpoint , but it didn't help.
As result as for now owner of Lakehouse - Lakehouse is a colleague who has since left our company.
ownet of Lakehouse - SQL Analytics Endpoint is me.

2 REPLIES 2
Anonymous
Not applicable

Hi @OlenaDumna ,

 

You may reassign the ownership of the Lakehouse an active user within your organization. 

For original post you could refer to :Re: Transfer ownership of a Fabric Lakehouse - Microsoft Fabric Community

Then verify that the new owner has the necessary permissions to access and manage the Lakehouse. You may need to update the permissions settings to ensure that the new owner has full access.

 

 

Best Regards,
Community Support Team _ Caitlyn

Hi, v-xiaoyan-msft

Preview
 
I already did this yesterday.
As you can see I am owner but not able to execute select query.
OlenaDumna_0-1735390207153.png

 

So I don't understant what else I should check ... but I need to fix this 
May be it is because of that I am only owner od SQL endpoint. 

OlenaDumna_3-1735288851782.png

 

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

June Fabric Update Carousel

Fabric Monthly Update - June 2026

Check out the June 2026 Fabric update to learn about new features.

Top Solution Authors
Top Kudoed Authors