Forum Discussion
Kusto/Azure Data Explorer Client Query Limits
Hi tessaw ,
What is the error message?
What connection mode have you adopted? Import or Direct Query?
It may be an error caused by a limitation in Power BI.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-lionel-msft , the actual error in PowerBI itself was not very descriptive, it only said that some of the rows failed to refresh/load. Only once I ran the query in Kusto/Azure Data Explorer itself did I get a descriptive error message which led me to the article I listed in the original post. Specifically, the error message was:
"The Kusto DataEngine has failed to execute a query: 'Query result set has exceeded the internal data size limit 67108864 (E_QUERY_RESULT_SET_TOO_LARGE).'"Hi tessaw ,
Considerations and limitations
Power BI also has restrictions on connected data.
Also you can refer to this:
Ten Techniques for Optimising Memory Usage in Microsoft Power BI
Best practices for using Power BI to query and visualize Azure Data Explorer data
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
