Refresh Error-There is not enough memory

[learner03]

I got this below error after waitin 1 and half hour of refresh-
The dataset is not even too large. 4 tables have only 15-20 lines and one has 1 month of timestamp data whici can have about 40,000 lines.

What should I do?

[v-stephen-msft]

Hi @learner03 ,

Please filter your resource table, and just load the necessary data. There are some tips about managing Memory, you can review them in this similar thread.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@learner03 , Under option and setting increase the cache memory.

Increase the virtual RAM of your system

Also, check how much RAM other processes are taking. Sometimes browsers takes too much of the memory and Power bi might not be getting enough

refer if needed

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=6cd37af6-...

[learner03]

@amitchandak How much cacke should I increase and this below is the current screenshot.

Also, how can I know what space the reports are taking? I find this a bit strange as uptill now  I have only 4 reports. I have published these 4 in service and it refreshes every 1 hour or 2 hour. Is this refresh related to memory consumption? My data source is a custom connector with .mez extension and given by the warehouse management syatem people and I use that source in the Get Data part.