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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

June FBC25 Carousel

Fabric Monthly Update - June 2025

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

Top Kudoed Authors