connect fabric table externally

[EnricoKirschke]

Hi, how can data be retrieved externally from lakehouse/fabric table (using postman)?

[Anonymous · Accepted solution]

Hi,lbendlin ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.
Hello,@EnricoKirschke .I am glad to help you.
Many thanks to lbendlin for his reply, he is correct in suggesting that for data retrieval one should use the Tabular Data Stream (TDS) protocol, through other drivers such as ODBC. Your later suggested research process is correct.
You could try starting the notebook in Lakehouse and connecting to Warehouse using a JDBC connection and then running the T-SQL included in python to run the transformation, note that running python commands is not directly supported in the Warehouse .
I hope you find the documentation link below helpful:
URL:www.linkedin.cn

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Is this what you are looking for?

Access Fabric data locally with OneLake file explorer - Microsoft Fabric | Microsoft Learn

[EnricoKirschke]

Hi, no file explorer usage,
I have to provide access to fabric data (source/bronze layer) to third party application by using REST API, third party has to read fabric-table.
Therefore I'm going to configure/test my lakehouse configuration i.e. endpoint, priviliges etc.
When I use Postman there is no sufficient reply yet, always authorization err. Validating with documentation gives no more clue how to debug proper connection. 
Are there any ideas how to validate/establish connection with Postman?

Thanks for reply.

[lbendlin]

You can't do that with an API call. You can use the SQL Endpoints.

[EnricoKirschke]

Okay, I have checked some more documentation (valid today), and so far:
REST API to Fabric works only for maintenance purposes, not for data retrieval?
For data retrieval by external access/tools only Tabular Data Stream (TDS8.0) is possible and thus for non Microsoft party only by ODBC or OLE DB drivers?

found here Connectivity to data warehousing - Microsoft Fabric | Microsoft Learn
and here What is the SQL analytics endpoint for a lakehouse? - Microsoft Fabric | Microsoft Learn
Is my research right and complete?