Forum Discussion
Helper IVMore RAM utilization in Power BI Desktop due to Large data from sharepoint folder
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.
Hi Ramendra
disable the option,
for more information, see
https://docs.microsoft.com/en-us/power-bi/guidance/power-query-background-refresh
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.
4 Replies
v-xiaotangCommunity Support
Hi Ramendra
disable the option,
for more information, see
https://docs.microsoft.com/en-us/power-bi/guidance/power-query-background-refresh
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
Super User
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.
