Hi @Muralikrishna Pirla ,
As per my analysis, this is a limitation from ADX. Result truncation is a limit set by default on the result set returned by the query. Kusto limits the number of records returned to the client to 500,000, and the overall data size for those records to 64 MB. When either of these limits is exceeded, the query fails with a "partial query failure". Because of which you are seeing the error message when you are trying to preview the data.
You can disable result truncation by using the
notruncation request option. We recommend that some form of limitation is still put in place.
set notruncation; MyTable | take 1000000
It's also possible to have more refined control over result truncation by setting the value of truncationmaxsize (maximum data size in bytes, defaults to 64 MB) and truncationmaxrecords (maximum number of records, defaults to 500,000). For example, the following query sets result truncation to happen at either 1,105 records or 1 MB, whichever is exceeded.
set truncationmaxsize=1048576; set truncationmaxrecords=1105; MyTable | where User=="UserId1"
The following apply when using set statements, and/or when specifying flags in client request properties.
notruncationis set, and any of
query_take_max_recordsare also set -
query_take_max_recordsare set multiple times - the lower value for each property applies.
For more info please refer to this document and let us know if you have further query: Limit on result set size (result truncation)
Hope this info helps.
Please don’t forget to
Accept Answer and
Up-Vote wherever the information provided helps you, this can be beneficial to other community members.