Forum Discussion

DouweMeer's avatar
DouweMeer
Impactful Individual
6 years ago

More power...

Sorry, have to start with it... 

 

So I have a report that runs during a refresh for about an hour. When the data download has been finished, the calculation step takes into place. This is where the report stands on 6.2 GB of memory in my task manager. Usually it takes another hour to make the calculations happen. However, I have 31 at my disposal. Anyway I can assign like 20 GB of memory to the report to make the calculation step go faster? 

10 Replies

    • DouweMeer's avatar
      DouweMeer
      Impactful Individual

      amitchandak , thank you for your reply. Looking at the suggestion it looks like the idea behind the answer is different from what I've been looking for. My issue is not the problem when you run out of memory. I don't have this issue. I have plenty of memory in surplus and want to get this assigned to the report to improve the refresh time. 

       

      Basically I have a containsstring on a large dataset which takes up most of the calculation time. I've managed to make it work because in the past the cached memory was enormous and killing the calculation. 

       

      Can this be done, assigning surplus memory to a report?

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support

    Hi DouweMeer ,

     

    I have no idea to assign more memory to you report.

    But you could configure the priority as high. Open Task Manager-->find Power BI desktop and right click it-->Go to details-->Right click it and set priority as high. It will assign more resource on report.

     

    • DouweMeer's avatar
      DouweMeer
      Impactful Individual

      v-eachen-msft 

      I thought, good suggestion. Then I saw the following:

      From looking at it, I assume it has been disabled by IT?

      • v-eachen-msft's avatar
        v-eachen-msft
        Community Support

        Hi DouweMeer ,

         

        Sorry, I didn't make it clear. Expand it and right click a program of it. Then select "Go to details".