Forum Discussion
How to read fabric data via Rest API or URI
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
9 Replies
- DennesTorresPower Participant
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
- v-cboorla-msftMicrosoft Employee
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-msftMicrosoft Employee
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-msftMicrosoft Employee
Hi sudhav
Following up to see if your query has been resolved. Please let us know if you have any further queries.
- AndreyBearAdvocate II
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=filesystemResource urls =
Base AD URL = https://storage.azure.com/
- sudhavHelper V
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
- AndreyBearAdvocate II
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?