Forum Discussion
Not enough Memory error on Premium Capacity
Hi Anonymous
What I would do is to have open your PBIX on your desktop and then 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. In my example below it is consuming 1.2GB of memory. If this goes to more than 25GB then you are over your capacility limit.
I would then suggest using DAX Studio and the Vertipaq analyzer to see what is taking up all the space.
Hi Anonymous
What I would do is to have open your PBIX on your desktop and then 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. In my example below it is consuming 1.2GB of memory. If this goes to more than 25GB then you are over your capacility limit.
I would then suggest using DAX Studio and the Vertipaq analyzer to see what is taking up all the space.
Hi,
thanks for your answer.
Unfortunately the error doesn't arise while importing data to power Bi Desktop, but in the service. As the size of some tables are so big, that I would not be able to load them into the desktop version, so I filter them before via SQL views that are connected via dataflows.
After not being able to solve this issue, the poer bi support team recommended to use autoscale, but unfortunately I get the same error for that. Do you have an idea how this can happen or what to do?
Thanks in advance!
Best,
Moritz
Yeah that is correct.
I would suggest trying Gen2 to see if that solves your issue?