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 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).

Need Help

2 Replies

  • 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.