Using Kusto Explorer with Fabric tables

[smpa01]

I am unable to connect Kusto Explorer to Fabric KQL DB. I am using the Query URI as cluster conenction in attempt to query the KQL Db from the explorer. I can use the same Query URI to connecto to the db using Azure Data Explorer and One Lake Catalog-> Kusto

[datacoffee · Accepted solution]

Hi

I've had similar problems using the Kusto.explorer app.

my way of getting this to work, is to make sure that the cluster uri is correct (obviously 😆) and that the connection is authenticated using the EntraId user. The last part took me some time to get to work for some tenants- but it is just a matter of time, retries and trying again (pun intended) 😊

I know this is not a solution, but it is the best I can do. I've gottenrhis to work using patience and resilience.

good luck 

[v-karpurapud]

Hi @smpa01 
Thank you for reaching out to the Microsoft Fabric Community Forum.

Kusto Explorer is specifically designed for querying Azure Data Explorer (ADX) clusters. While Microsoft Fabric KQL databases expose KQL endpoints, they are not full ADX clusters. As a result, the Query URI from OneLake or a Fabric KQL database does not function as a standard ADX cluster URI, even though it may appear similar.
 

Currently, Kusto Explorer does not support direct access to Fabric KQL databases, unlike native ADX clusters.However, tools such as the Azure Data Explorer Web UI and OneLake Catalog are integrated with the Microsoft Fabric access model, allowing them to correctly route and interact with Fabric KQL databases.
 

 If you need to query Fabric KQL databases, using Azure Data Explorer Web UI or OneLake Catalog which are the supported methods for interacting with Fabric-native KQL data.

For more detailed information, Please refer to the Microsoft official document:

Query data in a KQL queryset - Microsoft Fabric | Microsoft Learn

If this response resolves your query, please mark it as the Accepted Solution to assist other community members. A Kudos is also appreciated if you found the response helpful.

Thank you!

[smpa01]

@v-karpurapud 

Currently, Kusto Explorer does not support direct access to Fabric KQL databases

3:31  says otherwise

[v-karpurapud]

Hi @smpa01 

Apologies for any confusion in my previous response. To clarify, Kusto Explorer does support querying Fabric KQL Databases, but it does not provide direct access in the same way as traditional Azure Data Explorer (ADX) clusters. Ensure you have the cluster URI and any necessary authentication details. Also, check for any network restrictions or firewall settings that might be blocking the connection.

I have watched the video you provided and reproduced the steps successfully. Please make sure you are using the correct connection string for the Fabric KQL database. The connection string should be formatted correctly and include all necessary parameters. Also, verify that you have the appropriate permissions to access the Fabric KQL database from Kusto Explorer.

If this post helps, Kindly mark it as Accepted Solution.

Thank You!