Forum Discussion

sguenther's avatar
sguenther
Advocate II
10 years ago

Refresh Error: Not enough memory available for the application

Hey guys,

 

after expanding my reports further and further (50+ report pages + large data model) I get this error when trying to refresh my reports in the service.

 

Error Message:

The operation has been cancelled because there is not enough memory available for the application. If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the machine.

 

Does anyone know how to fix that?

 

Thanks!

Seb

10 Replies

  • ashishrj's avatar
    ashishrj
    Power Participant

    sguenther I have observed that Power BI Desktop tool user much RAM when working on it. In your case where the data set is too large with huge number of reports, only suggestion is to either increase your RAM (8/16GB) or create reports in parts (different pbix files with small set of reports). 

  • MattAllington's avatar
    MattAllington
    Community Champion

    sguenther to clarify, you are refreshing this in the Service - is that correct?  I am surprised that you would get a memory issue.  How many rows in your largest table?  How many Columns in the same table?  My guess is that you have too many columns, but that is just a guess.

    • sguenther's avatar
      sguenther
      Advocate II

      MattAllington yes, I experienced this error in the service and not in the PowerBI Desktop tool. That's why it is so surprising to me. Is there any way to upgrade my account in order for it to support larger reports and data models? Because if it runs in PowerBI Desktop it should also rin on the server IMHO.

       

      Largest table: 5 mio rows, 15 columns (mainly with low cardinality)

      • MattAllington's avatar
        MattAllington
        Community Champion

        Not that I am aware of

         

        How many rows in your largest table?  How many Columns in the same table?