Forum Discussion
How to Optimize Memory Usage?
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!
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
2 Replies
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