Forum Discussion
How to Turn OFF Efficiency Mode
Hi, Shelley
I understand your feelings and experiences very well, and the experience brought to us by the software lag will be very bad.
I'd love to help you with the issue, have you tried adjusting the allocable RAM for Power BI? As shown in the figure below:
A computer with 64G memory is generally enough if the amount of data is not large.If you feel that PBI runs slowly after creating measure or column, it may be that your formula has used too many iterations or repeated calculations.
As my computer showed, there is no way to control whether a piece of software goes into Efficiency Mode or not. This mode is determined by the Task manager software and whether to enter this mode. Other software is also usually subject to this rule:
When I reopen it, Task Manager re-judges whether to enter that mode or not:
I can't directly modify or disable the Task manager schema for you, it's beyond the scope of Power BI, which is essentially a piece of software that runs on win, and is subject to the same control as the Task manager.
For other performance optimizations or lag in Power BI itself, you can refer to the following articles:
You can use DAX studio or PBI preformance analyzer to monitor duration.
Here are some links about DAX optimization.
Evaluation configuration settings for Desktop - Power BI | Microsoft Learn
https://maqsoftware.com/expertise/powerbi/dax-best-practices
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Again, Jianpeng, As for the allocable RAM, do you have a suggestion as to what to change it to? My machine is currently at default 4096. I will try bumping it up, but if you have any suggestions, I'm interested in hearing them.
Based on my seven-plus years of experience with Power BI and several years with Qlik, his is one of my smaller models and the processes I'm running are pretty simple, so it shouldn't be this slow.
Thanks again for your help.