Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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.
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.
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.
@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
Hi Amit,
It does not help.
Situation is same as of now.
User | Count |
---|---|
94 | |
79 | |
73 | |
63 | |
58 |
User | Count |
---|---|
110 | |
103 | |
84 | |
65 | |
62 |