How to read fabric data via Rest API or URI

[sudhav]

Hi Team, 

I need to read the fabiric lakehouse  data from REST API, i heard some thing like URI , can anybody tell me what it is and how can i read the data through REST API

TIA

[AndreyBear]

First, read this - OneLake API Parity - Microsoft Fabric | Microsoft Learn

Both blob and DFS rest api will work. 
A general template is (e.g., folder read):

GET https://onelake.dfs.fabric.microsoft.com/{workspace-guid}/{lakehouse-guid}?recursive=True&resource=filesystem

Resource urls =

• DFS - https://onelake.dfs.fabric.microsoft.com
• BLOB - https://onelake.blob.fabric.microsoft.com

Base AD URL = https://storage.azure.com/

[sudhav]

Hi Thankyou for response.

where should i run the above code..?

my requirement is if i have reporting tools like tableau/qlik/zoho, is it possible to connect to fabric using the above URL  from those repoting tools?

please let me know

TIA

[AndreyBear]

Anything that can send an API request with headers will work.  And I mean anything. Edge dev tools, Chrome dev mode, Postman, Powerautomate/Logic Apps/Azure Functions, PowerShell, Excel, curl, py, R, js, etc etc. Probably even Netscape Navigator.  You'll just need to generate a valid authorization token to pass along with the call.
Can tableau/qlik/zoho ETL from an HTTP call?

[v-cboorla-msft]

Hi @sudhav 

Welcome to Fabric Community and thanks for posting your question here.

Can you please look into relevant document in order to understand more about URI - how to read the fabric lake house  data from REST API.

How do I connect to OneLake? - Microsoft Fabric | Microsoft Learn

I hope this information is helpful. Please let me know if you have any other questions.

[v-cboorla-msft]

Hi @sudhav 

Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.

[v-cboorla-msft]

Hi @sudhav 

Following up to see if your query has been resolved. Please let us know if you have any further queries.

[sudhav]

Hi, 

I already created a case 

.( TrackingID#2309210010001127)

can you please follow up this and push forward.

[v-cboorla-msft]

Hi @sudhav 

Thank you for your response and raising Support ticket, we are reaching out to engineers to get update ASAP.

[DennesTorres]

Hi,

I don't think this is exactly what you want, but it may give you some clues: https://blog.gbrueckl.at/2023/08/querying-power-bi-rest-api-using-fabric-spark-sql/

Kind Regards,

Dennes