Forum Discussion
Powerbi to Azure Data explorer
Hi ,
I am trying to import data from Azure data explorer to powerbi i have filtered data but still am facing issue. Below is the screenshot for reference.
Can someone please help me.
Thanks in advance
Hi Anonymous ,
Based on the error description, the query exceed the limit of 500000 records.
Try to change the query to consume fewer resources.
Besides, reduce the result set size by modifying the query to only return interesting data.
You can view the following documents to learn more about how to deal with the error.
Kusto query result set exceeds internal limit - Azure Data Explorer | Microsoft Learn
Query limits - Azure Data Explorer | Microsoft Learn
Power Query Azure Data Explorer (Kusto) connector - Power Query | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous ,
Based on the error description, the query exceed the limit of 500000 records.
Try to change the query to consume fewer resources.
Besides, reduce the result set size by modifying the query to only return interesting data.
You can view the following documents to learn more about how to deal with the error.
Kusto query result set exceeds internal limit - Azure Data Explorer | Microsoft Learn
Query limits - Azure Data Explorer | Microsoft Learn
Power Query Azure Data Explorer (Kusto) connector - Power Query | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.