PowerBI Apps: Not Enough Memory To Complete This Operation

[Anonymous]

Datasets were updated automatically at a certain interval at https://app.powerbi.com/ - the source is a database hosted on Azure. Currently 2.5GB/10GB memory is used. Right now we get an error message "Not Enough Memory To Complete This Operation" with a dataset, although 7.5GB are still free.

The overviews in PowerBI are not created and pushed directly from a workstation again and again, so lack of RAM of a local device should not be the problem (one of the first hits on Google). The overviews were created on a work computer,  successfully pushed on PowerBi Apps (https://app.powerbi.com/) and there is a refresh interval (1x per day) - and exactly when updating is processed, the error message appears (warning message via Email).

[nitishsh91]

Hi @Anonymous 

I have faced this kind of issue in past where in I did a bit of research and updated 2 parameters in Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config :

CPUUtilizationPercentageThreshold

MemoryUtilizationPercentageThreshold

Please have a look at below url:

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-performance

I observed same behaviour and found out that it was not using all the resources available as there is a default value setup causing failure.

[Anonymous]

Thanks for the tip @NIT . We were able to trace the problem back to our DB server. Several update intervals run in parallel on Power BI and the server can hardly do this with 2 vCPU cores. I think we have to manage the update intervals better or generally increase the servers vCPUs. I'll take a closer look at your tip with the config anyway, thanks.