46 MB pbix file cannot refresh in the powebi app - Memory Allocation Issue

[RogerSteinberg]

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 

[v-lili6-msft]

hi @RogerSteinberg 

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

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/94758523-b9fa-4567-b3d9-1759abb54a84/you-ha...

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.

[Greg_Deckler]

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