Forum Discussion

Leonid_Kostin's avatar
Leonid_Kostin
Icon for Advocate I rankAdvocate 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
Icon for Super User rankSuper 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
Icon for Advocate I rankAdvocate 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
    Icon for Community Support rankCommunity 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!

    • Leonid_Kostin's avatar
      Leonid_Kostin
      Icon for Advocate I rankAdvocate I
      5 years ago

      Hi, v-kelly-msft .

       

      Yeah, i've done all the items from your list and checked the website. Going to test it for the upcoming week(s) and will respond later if the problem keeps bugging me. Thanks for your reply!