Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

PowerBI Apps: Not Enough Memory To Complete This Operation

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 messag...
Need Help
nitishsh91's avatar
nitishsh91
Icon for Solution Supplier rankSolution Supplier
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    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.