Forum Discussion
Post Patron46 MB pbix file cannot refresh in the powebi app - Memory Allocation Issue
Hi,
My file is only 46MB. I have 13 sql server queries which are extremely basic : select x,y,z from table where a=10
I can refresh without a problem in the power bi desktop. As soon as I try to refresh manually or through a schedule in the service. I get the same error message every single time:
You have reached the maximum allowable memory allocation for your tier. Consider upgrading to a tier with more available memory.
Definitely size isn't an issue in this case. So does have to do with multiple queries being run at the same time ? If so , i Know there is no way of disabling parallel loading in the service.
If it's not that then why should we upgrade to higher tier for this ?
Thank you
3 Replies
- Greg_Deckler
Community Champion
RogerSteinberg You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET". 
v-lili6-msftCommunity Support
Try to update the gateway to the latest version,
and set refresh time at a free time that has no other schedule refresh at this time.
and sometime this may be a temporary error.
You could have a reference of these two similar threads which have been solved.
https://stackoverflow.com/questions/45634697/azure-analysis-services-maximum-allowable-memory-issue
Regards,
Lin
- RogerSteinberg
My gateway is up to date. I refreshed it during busy server hours and when no one is querying so those are not the issues.
