cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rumittal Regular Visitor
Regular Visitor

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

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:

 

Result_truncation_TRUE.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Still below error is shown : 

 

LoadError.PNG

2 REPLIES 2
Community Support Team
Community Support Team

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

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.

Community Support Team
Community Support Team

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

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.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 185 members 2,076 guests
Please welcome our newest community members: