Error in importing larget dataset for Azure data Explorer with truncation set to false

[rumittal]

I am trying to import data a table having '1233587' rows from Azure data explorer, and facing below error : Even though I have set disable truncation to TRUE and '1233587' rows doesnt exceed the limit '2147483647' in below error message.

Could you please help with what could be going wrong here?

Error message:

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataFormat.Error] The number of items in the list is too large. Buffered lists can support up to 2147483647 items and streamed lists can support up to 4503599627370496 items.

In Advanced options, set disable truncation to TRUE:

Still below error is shown : 

[v-xuding-msft]

Hi @rumittal ,

Have you solved the issue? If yes, you could share the solution. More people who experience it will benefit here. If no, do you try to change connection mode that I suggested? Is there any error message?

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.

[v-xuding-msft]

Hi @rumittal ,

I think it is caused by the import mode. When our data set is very small, we could use import mode. For your requirement, there are  '1233587' rows in your data model.  You could try Direct Query mode. And change the option of "Disable result-set trunction" to false. Then it will generate a set truncation.

Here are the related documents that you could reference.

Best practices for using Power BI to query and visualize Azure Data Explorer data

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.