Forum Discussion
How to Onboard Large Datasets in PowerBi
Hi! I am working on a medium sized data set and when I run the Kusto Query in the Power Bi desktop version I receive this error:
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [Expression.Error] Query execution has exceeded the allowed limits (80DA0003): The results of this query exceed the set limit of 64 MB, so not all records were returned (E_QUERY_RESULT_SET_TOO_LARGE, 0x80DA0003). See https://aka.ms/kustoquerylimits for more information and possible solutions.. [0]Kusto.Data.Exceptions.KustoServicePartialQueryFailureLimitsExceededException: Query execution has exceeded the allowed limits (80DA0003): The results of this query exceed the set limit of 64 MB, so not all records were returned (E_QUERY_RESULT_SET_TOO_LARGE, 0x80DA0003). See https://aka.ms/kustoquerylimits for more information and possible solutions.. ErrorCode= ErrorReason= ErrorMessage= DataSource= DatabaseName= ClientRequestId= ActivityId=00000000-0000-0000-0000-000000000000 UnderlyingErrorCode=80DA0003 UnderlyingErrorMessage=The results of this query exceed the set limit of 64 MB, so not all records were returned (E_QUERY_RESULT_SET_TOO_LARGE, 0x80DA0003). See https://aka.ms/kustoquerylimits for more information and possible solutions. . '.
1 Reply
- AnonymousNot applicable
Hi Anonymous ,
This is the related document, you can view this content:
kql - How can i query a large result set in Kusto explorer? - Stack Overflow
Kusto query result set exceeds internal limit - Azure Data Explorer | Microsoft Learn
kql - Kusto: How to query large tables as chunks to export data? - Stack Overflow
Solved: powerbi online kusto query execution error, but no... - Microsoft Fabric Community
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.