Unable to Connect to Subset of a KQL Table

[jlong1014]

I am attempting to connect to an Event House KQL Cluster within a Fabric environment to a development instance of Data-Formulator. When I run a KQL query to get a subset of a large database I receive the following React below. I was able to successfully connect to the KQL database, however pulling in any full table from this database would be too large of a dataset to use for this purpose. I am running this in a Linux environment via the PyPi package (I have also ran into the same issue after setting it up as instructed in Developers.md) Could someone take a look at the KQL Connector (specifically the query connection). Please let me know if any extra details are needed to diagnose this issue!

[Chenglong-MS]

Would like to check, it seems like it's a frontend issue. Right now there are issues directly executing KQL in the interface, and are we considering deprecating the excuting query feature (which poses risks). Is it possible to directly load the table? Or probably we can enhance the data loader to limit size of the data to be loaded.

[jlong1014]

Would like to check, it seems like it's a frontend issue. Right now there are issues directly executing KQL in the interface, and are we considering deprecating the excuting query feature (which poses risks). Is it possible to directly load the table? Or probably we can enhance the data loader to limit size of the data to be loaded.

Unfortunately, this table is too large to load in its entirety. I was interested in being able to visualize the most recent data from the table. The query KQL feature would allow us to do that within the application. If you were to limit the size of the data loaded, would it be possible to allow the user to choose maybe the sorting criteria? Say, if you only take the top 10,000 rows, the user can define what the ORDER BY clause sorts on.

[Chenglong-MS]

This makes a lot of sense, will include this feature in this week's update.

[Chenglong-MS]

Please take a look at the latest version! The subset option allows you to import a subset of rows sorted by columns. Plus some new feature for keep alive with Kusto data: https://github.com/microsoft/data-formulator/releases/tag/0.6