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

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Reply
sudhav
Helper V
Helper V

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 9
AndreyBear
Advocate I
Advocate I

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 =

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

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

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
Community Support
Community Support

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.

Hi @sudhav 

 

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

Hi @sudhav 

 

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

Hi, 

I already created a case 

.( TrackingID#2309210010001127)

 

can you please follow up this and push forward.

Hi @sudhav 

 

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

DennesTorres
Impactful Individual
Impactful Individual

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

JanFabricDE_carousel

Fabric Monthly Update - January 2025

Explore the power of Python Notebooks in Fabric!

JanFabricDW_carousel

Fabric Monthly Update - January 2025

Unlock the latest Fabric Data Warehouse upgrades!