Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
Please help me how to optimize the memory usage in Power BI Desktop. I got the message that I've runned out of memory during refresh. I've a complex database with many calculated columns, and about 10 tables. I'm running a 64 bit version with 8 GB memory. I tried to delete columns which are needn't but it's not enough!
Thank you in advance for your help!
Solved! Go to Solution.
Hi @Anonymous,
I would suggest using Direct Query instead of import mode. Adding more memory is also a good idea. Besides, I can't find out a good method that can make a big change. There are also many post you can reference:
1. power-bi-performance-tips-and-techniques
2. Power-BI-in-memory-RAM-Overload
3. powerbi-learning-2-4-optimize-data-models
Best Regards!
Dale
Hi @Anonymous,
I would suggest using Direct Query instead of import mode. Adding more memory is also a good idea. Besides, I can't find out a good method that can make a big change. There are also many post you can reference:
1. power-bi-performance-tips-and-techniques
2. Power-BI-in-memory-RAM-Overload
3. powerbi-learning-2-4-optimize-data-models
Best Regards!
Dale
Hi Dale!
Thank you for your help, I will try to do the model with Direct Query instead of Import!
Regards,
Mate
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
49 |
User | Count |
---|---|
144 | |
109 | |
108 | |
87 | |
61 |