PowerQuery submits the same query to Kusto Cluster multiple times when Refreshing a Table Preview

[Brandt]

Recently we've noticed that Power BI Data Sources that query data from Kusto Clusters will submit the kusto query to the cluster multiple times when refreshing the table preview.  This appears to occur whether the query to the cluster is succeeding or failing.  I've personally seen a refresh of a Data Table submit up to 20 duplicate queries to the Kusto Cluster when it should only need to be sending one.

This can be a major problem for Kusto if the Kusto query is pushing the limits of the cluster already.  We've seen this issue contribute to taking down a cluster completely.

Power BI Desktop Version: 2.56.5023.1021 64-bit (March 2018)

[v-qiuyu-msft]

Hi @Brandt,

Please check if this option is turned off: 

How many duplicate requests for the same query send to source after you turned off this option? 

Best Regards,
Qiuyun Yu 

[Brandt]

Thanks Qiuyun and Vicky!  That was absolutely the cause of the duplicate queries being sent.  Disabling that option made it so only a single query gets sent to kusto when a Refresh or Preview Refresh is made.

Cheers! 🙂