Forum Discussion
How to Turn OFF Efficiency Mode
Thank you Anonymous Jianpeng as this gave me something to try, but I could not modify the shortcut in Windows 11 to turn off Efficiency Mode as the poster had suggested.
My best luck to this point has been thanks to one of my teammates who suggested downloading Power BI from the Power BI site NOT the Microsoft Store. From the site, Power BI does not perform the same "auto" efficiency mode in Windows, and so my performance has improved; HOWEVER, it is still very slow in refreshes as well as any steps in the query editor. I looked in the Task Manager, and it appears that Webview 2, which Power BI is using is going into Efficiency Mode just like Power BI Desktop was, and again, I cannot disable it. This is so frustrating.
I posted inside our company team and several others are pinging me about their complete frustration with how slow Power BI is for them too. Please, please bring this to the attention of your Power BI people so they can have some impact and/or influence with the Windows team as this is really giving Power BI a bad reputation.
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.