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

Join us at the 2025 Microsoft Fabric Community Conference. March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for $400 discount. Register now

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
v-xiaoyan-msft
Community Support
Community Support

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