Memory error: You have reached the maximum allowable memory allocation for your tier.

[Anonymous]

Hello, One of my reports is giving me error like the below,
Memory error: You have reached the maximum allowable memory allocation for your tier. Consider upgrading to a tier with more available memory.

Earlier that same report was not giving me any while refreshing. but from the last few days, I'm facing this error while the On-demand refresh.
I have tried a few suggestions also which are given here in the community. but those are not working for me and still facing errors.
please help me out with that error.
Thanks.

[v-yetao1-msft · Accepted solution]

HI @Anonymous 

You need to upgrade the shared capacity with premiumn capacity to solve this problem, because you have used resources that exceed the upper limit, or you need to optimize the underlying data source to make the query return less data.  

You can download the pbix file and refresh it, see how much memory it consumes when refreshing. You can monitor this by going into task manager and looking for "msmdsrv.exe" this is the analysis services engine.  

If you exceed the allowable capacity, then you will want to consider upgrading your capacity to Premium capacity and purchasing the appropriate SKUs.

What is Power BI Premium Gen2? - Power BI | Microsoft Learn

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pjg]

We had an error like this in our test enviroment, but the report worked fine in our premium live enviroment. 
Im not sure if its the exact same message as I didn't record it and was a couple of months ago, but the report PBIX was just over 1gig in size.
We reduced the dataset size by only importing fields from data tables that are used in the report. Some fields had been imported by the developer but not used in the report. A couple of the fields contained a lot of data like ASCII encoded attachements so this worked well. As an extra step, we also excluded very old historical data and kept only a rolling 3 years in the report.
After we dropped the unused fields, limited the number of years of data, it has been working fine since and is about 1/3 of the size.
Im guessing your have tried this as the error message would point you in this direction, but posted just incase as you had not said what you have tried.
Hope it helps.