Exploring data in Fabric Data Warehouse and Lakehouse in Azure Data Explorer

[vivek_goli]

I want to explore and run queries on data present in Fabric Data Warehouse or Lakehouse in Azure Data Explorer without actually ingesting the data into ADX. Is there any way to use Fabric tables as external tables in Azure Data Explorer?

[v-menakakota]

Hi  @vivek_goli  ,
Thanks for reaching out to the Microsoft fabric community forum. 

If your Lakehouse data in OneLake is in Delta format, you might be able to query it from Azure Data Explorer (ADX) using the external_table() function, which is currently in preview. This lets you read the data without fully importing it into ADX.
Currently, Azure Data Explorer (ADX) doesn't support directly querying tables from Fabric Data Warehouse or Lakehouse as external tables unless the data is ingested or connected through supported sources.
Please go through the Documentation link:
Create database shortcut for Azure Data Explorer database - Microsoft Fabric | Microsoft Learn

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

Best Regards, 
Menaka.
Community Support Team

[vivek_goli]

The link you have provided seems to provide the reverse of what I have asked. Correct me if I am wrong and explain the process please

[v-menakakota]

Hi @vivek_goli ,

Really sorry for the previous documentation. Currently, Azure Data Explorer (ADX) doesn't support directly querying tables from Fabric Data Warehouse or Lakehouse as external tables unless the data is ingested or connected through supported sources.
If your Lakehouse data in OneLake is in Delta format, you might be able to query it from Azure Data Explorer (ADX) using the external_table() function, which is currently in preview. Which may take few days.

Thanks for reaching out to the Microsoft fabric community forum. 
Best Regards, 
Menaka.
Community Support Team

[v-menakakota]

Hi  @vivek_goli ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily. 

 
Thank you. 

[vivek_goli]

I tried to load but did not find an option to load external tables from Fabric or ADLS gen2

[v-menakakota]

Hi @vivek_goli ,

Since you're not seeing the option to load external tables from Fabric or ADLS Gen2, there could be a configuration or permission-related issue specific to your environment. To get this resolved quickly and accurately, I recommend raising a support ticket with Microsoft. The support team will be able to investigate your setup in detail and guide you through the necessary steps.

Please refer below link on how to raise a contact support or support ticket. 
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn 

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
Best Regards, 
Menaka.
Community Support Team.

[v-menakakota · Accepted solution]

Hi @vivek_goli ,

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.