Powerbi to Azure Data explorer

[Rup10]

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

[Anonymous · Accepted solution]

Hi @Rup10 ,

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 practices for using Power BI to query and visualize Azure Data Explorer data - Azure Data Explo...

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.