Forum Discussion

Leonid_Kostin's avatar
Leonid_Kostin
Advocate I
5 years ago
Solved

Out of Memory exception

Hello, dear Power BI experts.    Don't know, if it's a coincidence or not, but after the July 2021 Desktop release, I sterted to get more errors related to memory. Sometimes when I work with 2 file...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  Leonid_Kostin ，

     

    Have you downloaded 64 bit version Power BI desktop?

    Try to increase the Maximum allowed to 16000 under File / Options and Settings / Options / Global / Data Load.  Data Cache Management Options.

    Besides,below troubleshooting may help:

    https://windowsreport.com/memory-error-allocation-failure/

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

amitchandak's avatar
amitchandak
Super User
5 years ago

Leonid_Kostin , In file -> Options and Settings -> Option -> data load.

Increase the cache memory 

 

Open power query and reduce the size of import data using filter or parameters 

Leonid_Kostin's avatar
Leonid_Kostin
Advocate I
5 years ago

Hi, amitchandak .

 

Thank you for the quick reply.

As I said earlier, I increased it to:

 

By default it was 4096 as far as I remember. 

Is the current value not enough? I can still increase it a bit but are there any others places or options where I need to double check? 

 

Thank you.

 

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Leonid_Kostin , I am facing the same issue as of now. I am not able to work on files above 2.2 GB. They only way I am getting rid I removed the data from tables in the power query.

    I am planning to move few tables to power query and use direct query as I have a premium workspace.

     

    As I do not have developement database, Not able to use developement pipeline

    • Leonid_Kostin's avatar
      Leonid_Kostin
      Advocate I
      5 years ago

      amitchandak , I see your point...have you heard any comments from MS? I hope they can fix it in the upcoming releases. Otherwise it's a big pain...

       

      Thank you.

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        5 years ago

        Hi  Leonid_Kostin ，

         

        Have you downloaded 64 bit version Power BI desktop?

        Try to increase the Maximum allowed to 16000 under File / Options and Settings / Options / Global / Data Load.  Data Cache Management Options.

        Besides,below troubleshooting may help:

        https://windowsreport.com/memory-error-allocation-failure/

         

        Best Regards,
        Kelly

        Did I answer your question? Mark my reply as a solution!