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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Sajeda_Sultana
Regular Visitor

Unable to access table in Lakehouse

Hi everyone,  I am trying to access a table in Lakehouse using rest API. But it shows error (Status code 401 {"error":{"code":"Unauthorized","message":"Authentication Failed with Bearer token is not present in the request"}}). 

 

My Lakehouse table get url: https://onelake.dfs.fabric.microsoft.com................... 

 

Has anyone experienced this? Any insight or tips would be much appreciated!

4 REPLIES 4
Sajeda_Sultana
Regular Visitor

Hi @v-cboorla-msft 

Thank you for your response. It's working on Get request. But it shows other error when I am trying Post request.

I am following this documentation: Path - Lease - REST API (Azure Storage Services) | Microsoft Learn

But I am not able to solve the problem. Please help me to fix the problem.rest-api-fabric.png

 

v-cboorla-msft
Community Support
Community Support

Hi @Sajeda_Sultana 

 

Thanks for using Fabric Community.

Apologies for the issue that you are facing.

Could you please share some details about how you are trying to access the table in Lakehouse using rest API? Can you send me the screen shot of the error message? In order to understand the issue clearly and helps you in a better way.

 

Thanks

 

fabric_issues01.pngfabric_issues.pngThank you for your quick response. I am trying to access specific table from Lakehouse. But it shows authentication error. 

Hi @Sajeda_Sultana 

 

Apologies for the inconvenience.

How you are you authenticating? The bearer token must be generated from Microsoft Entra - UPN or SPN. You should be able to use Get-AzAccessToken for the Storage audience using the -ResourceTypeName parameter. This has to be passed as part of the request header.

Please see the documentation: How do I connect to OneLake? - Microsoft Fabric | Microsoft Learn

 

I hope this helps. Please do let us know if you have any further questions.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

March 2024  FBC Gallery Image

Fabric Monthly Update - March 2024

Check out the March 2024 Fabric update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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