Unable to access table in Lakehouse

[Sajeda_Sultana]

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!

[Sajeda_Sultana]

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.

. 

[v-cboorla-msft]

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

[Sajeda_Sultana]

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

[v-cboorla-msft]

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.