Refresh Error: Not enough memory available for the application

[sguenther]

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

[MattAllington]

@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]

@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]

Not that I am aware of

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

[valter_herman]

This was very helpful.  I reduced the number of columns using the "Choose Columns" button and that solved my issue.  It was easy to filter by "base" to quickly remove a lot of the base currency fields that I didn't need (no multi-currency here).

[LP7]

Hi,

I got the same Error. would mine explaining what is this button, I couldn't find it online

Thanks

[valter_herman]

Sure -

1. open up your Power BI desktop application

2. open your Power BI file

3. click on "Edit Queries"

4. a new window should show.  find your table on which you'd like to update your columns on the left

5. click "Choose Columns" from the menu at the top

[Anonymous]

Thank you. It has helped me as well

[sguenther]

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

[MattAllington]

Sorry for asking - you just never know. I guess since it is in the service, you could send a frown and someone should be able to monitor the refresh to see what is happening. 

[ashishrj]

@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).