Evaluation ran out of memory and can't continue RRS feed

  • Question

  • Hi,

    I am trying to work on 12 different excel files with 3 sheets each and almost 600,000 rows in each sheet. That makes it a total of around 4 GB data. I basically want to:

    1-Filter out data from the unified data of all files

    2-Summarize data combining all sheets. Sort of data which I usually get from a Pivot Table from a sheet.

    Can I even do that operation on that size of data through Power Query? because the only reason for me to try out Power Query is to enable myself to work on that huge data altogether.

    If I look at the loading status at the bottom right of the screen, after processing 3 files it give me the message "Evaluation ran out of memory and can't continue". It would be of great help if someone can tell me how to do it or otherwise tell me to stop wasting my time if this is not possible with the limited resources I have on my laptop.

    Thanks in advance.

    Asif Shaikh   

    Wednesday, January 16, 2019 9:14 AM


  • Hi Asif. Are you using Excel x64 or x86? Using the 64-bit version will allow Power Query to use more RAM (as long as it's available). If you're unable to switch to Excel x64, another option would be to combine the data using Power BI Desktop x64.


    Wednesday, January 16, 2019 7:47 PM