More power...

[DouweMeer]

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? 

[v-eachen-msft]

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]

@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]

Hi @DouweMeer ,

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

[DouweMeer]

@v-eachen-msft 

I can't spot it either down there:

[lbendlin]

If you look under File...Options and Settings...Options...Global...Data Load - you can up the maximum allowed Data cache. Maybe that works.

[DouweMeer]

@lbendlin 

As far as I know, assigning more cached memory is only when you run out of 'memory'. The cached memory is where intermediary tables are stored, or filter contexts. I don't breach it and with assigning more data to this cached memory nothing extra is stored there. 

@v-eachen-msft 

Hmm, found it :). I'll give it a try later on when I need another refresh.

[v-eachen-msft]

Hi @DouweMeer ,

You are close to it. Click "Go to details" which is shown in your image above. Then follow my first reply to set its priority.

[DouweMeer]

@v-eachen-msft 

Nothing happens. Memory keeps sitting on the same value sadly enough. 

[amitchandak]

@DouweMeer , refer is these two can help

https://windowsreport.com/memory-error-allocation-failure/

https://www.youtube.com/watch?v=IRPEAIgZeY8

[DouweMeer]

@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?