topic Re: How to read fabric data via Rest API or URI in Pipelines

How to read fabric data via Rest API or URI

sudhav — Wed, 20 Sep 2023 11:33:21 GMT

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

Re: How to read fabric data via Rest API or URI

DennesTorres — Fri, 22 Sep 2023 11:36:29 GMT

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

Re: How to read fabric data via Rest API or URI

v-cboorla-msft — Mon, 25 Sep 2023 15:35:46 GMT

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.

Re: How to read fabric data via Rest API or URI

v-cboorla-msft — Wed, 27 Sep 2023 04:07:39 GMT

Hi sudhav

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

Re: How to read fabric data via Rest API or URI

AndreyBear — Wed, 27 Sep 2023 20:30:28 GMT

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/

Re: How to read fabric data via Rest API or URI

v-cboorla-msft — Thu, 28 Sep 2023 11:55:28 GMT

Hi sudhav

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

Re: How to read fabric data via Rest API or URI

sudhav — Thu, 28 Sep 2023 12:44:04 GMT

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

Re: How to read fabric data via Rest API or URI

sudhav — Thu, 28 Sep 2023 12:45:17 GMT

Hi,

I already created a case

.( TrackingID#2309210010001127)

can you please follow up this and push forward.

Re: How to read fabric data via Rest API or URI

v-cboorla-msft — Fri, 29 Sep 2023 05:43:59 GMT

Hi sudhav

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

Re: How to read fabric data via Rest API or URI

AndreyBear — Thu, 26 Oct 2023 02:14:41 GMT

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?