locked
Excel Power Query Ram Utilisation seems to be block to 4 Mo RRS feed

  • Question

  • Hello

    I am manipulating huge file with Excel 2016 (365) 64 Bits power Query 32 million of lignes.

    It work prety well. Of course, I would like it to be faster... 

    I upgraded my RAM memory from 8 to 16 Go with not the target result at the end. It is true that it work better, but Excel don't use as much as memory a I would like.

    I am charging the Excel model into PowerQuery to run the same request.

    As you can see, Power query use the all the available memory, where Excel seems to have a RAM Limitation.

    Do you know if it is plan to make Excel run with the all available memory ?

    Thanks in advance !

    Result in EXCEL

    Result in Power BI

    Wednesday, March 28, 2018 12:24 PM

Answers

  • Hi Jerome,

    Currently there are no plans in Excel to utilize all of the available memory.

    Guy

    - Excel Team


    Guy Hunkin - Excel Team

    Tuesday, May 22, 2018 10:15 AM

All replies

  • Hi Jerome,

    Currently there are no plans in Excel to utilize all of the available memory.

    Guy

    - Excel Team


    Guy Hunkin - Excel Team

    Tuesday, May 22, 2018 10:15 AM
  • Hi Guy,

    Thank for the feed back.

    It is not a good news. It would be so wonderfull to have it.

    Jerome

    Tuesday, May 22, 2018 11:36 AM