How to Optimize Memory Usage?

[Anonymous]

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!

[v-jiascu-msft · Accepted 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

[Anonymous]

Hi Dale!

Thank you for your help, I will try to do the model with Direct Query instead of Import!

Regards,
Mate