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.
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.