• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Table 255 Rows limit reached during Power Query data loading

Volto66

New Member
Hi there, I was loading data using a Power Query starting from a table of data of 26K rows (6.5MB) and the results is a table with more than 255 rows.
the loading process stopped and I received an error saying "The query returned more data than will fit in a worksheet".

I've tried also to use data model but also there I received the following error: "Memory error: A record (65581 bytes) was encountered that exceeds the maximum page size of the storage object (65528 bytes).

Is there any way to go beyond this limits?

Thanks for your support.
 
PQ does not have a 255 row limit (it would be pretty useless if it did) so I think there must be something odd in your dataset. Can you post a sample file?
 
Back
Top