More RAM utilization in Power BI Desktop due to Large data from sharepoint folder

[Ramendra]

Hi Team,

I  have 16 GB RAM in my computer and I am facing more RAM utilization in Power BI Desktop due to Large data from sharepoint folder. I am not able to work  on power BI desktop due to this situation but I have to connect more data as well.

The pbix is below  20 MB but it takes whole RAM and system is not responding when trying to open file again to prepare further data and visualization.

Could you please help me here to solve this kind if issues.

[v-xiaotang · Accepted solution]

Hi @Ramendra 

disable the option,

for more information, see

https://docs.microsoft.com/en-us/power-bi/guidance/power-query-background-refresh

https://blog.crossjoin.co.uk/2016/12/05/power-query-power-bi-and-the-allow-data-preview-to-download-...

if problem still persists, please let me know.

Best Regards,

Community Support Team _ Tang

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

[Ramendra]

Hi @v-xiaotang,

This was perfect solution. I disabled "Parallel loading of tables" and "background data" as well as "auto detect new relationships" option.
Now I am able to open my PBIX quickly and I am able to work on it.
Now I can make bigger data model.

Thanks for help.

[amitchandak]

@Ramendra , Under file options and setting -> Options 

Increase  data Management Cache

Try to change it from 4096 to 8192 and check

If need increase Virtual Memory

[Ramendra]

Hi Amit, 
It does not help.
Situation is same as of now.