Forum Discussion
connect fabric table externally
Hi, how can data be retrieved externally from lakehouse/fabric table (using postman)?
Hi,lbendlin ,thanks for your concern about this issue.
Your answer is excellent!
And I would like to share some additional solutions below.
Hello,Anonymous .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.
5 Replies
Is this what you are looking for?
Access Fabric data locally with OneLake file explorer - Microsoft Fabric | Microsoft Learn
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.
You can't do that with an API call. You can use the SQL Endpoints.
Hi,lbendlin ,thanks for your concern about this issue.
Your answer is excellent!
And I would like to share some additional solutions below.
Hello,Anonymous .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.
