Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@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.
@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)
Not that I am aware of
How many rows in your largest table? How many Columns in the same table?
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).
Hi,
I got the same Error. would mine explaining what is this button, I couldn't find it online
Thanks
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
Thank you. It has helped me as well
Largest table: 5 mio rows, 15 columns (mainly with low cardinality)
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.
@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).