How to Onboard Large Datasets in PowerBi

[Anonymous]

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.Exceptio...https://aka.ms/kustoquerylimits for more information and possible solutions.. ErrorCode= ErrorReason...https://aka.ms/kustoquerylimits for more information and possible solutions. . '.

How can I onboard this data?

[Anonymous]

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.