How to query Fabric warehouse tables from Azure ML using SQL?

[michalzeman]

Hello,

How can I query Fabric warehouse table from Azure ML using SQL?

The Azure ML documentation describes a way to set up a OneLake datastore, but that approach does not seem to support running more complex SQL queries directly on the data.

[v-prasare]

Hi, We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

[burakkaragoz]

I think you can try the following steps.

-Use the Azure Synapse Analytics connection - Fabric data warehouses integrate with Synapse, you can run SQL queries through this connection
-Using Python notebooks in Azure ML, connect to the Fabric data warehouse via pyodbc or SQLAlchemy and run queries
-Try querying data using SQL endpoints for Fabric lakehouses

[v-prasare · Accepted solution]

Hi @michalzeman,

If your getting blocked on this, In this scenario i suggest you to raise a support ticket here. so, that they can assit you in addressing the issue you are facing. please follow below link on how to raise a support ticket:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Thanks,

Prashanth Are