Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I figured that Power BI Desktop is programmed in a way that maximum possible number of refreshing is guaranteed.
For example I created a new measure without inserting it the report, and when I come back to the Report page all visuals start refreshing. It almost feels like "Hey you know what, I'm too lazy to check if this action brings change to X, so maybe just refresh ABCD....XYZ for whatever action so at least I don't get blamed for potentially losing user actioins".
For a big report that takes a while to load, this is the killer for productivity. Many reports are NOT created for presentation but for research, because Excel cannot take large dataset and PowerPivot is buggy, so Power BI basically serves as an enhanced Excel. These reports typically take 5 minutes or even more to refresh (consider a report with a lot of matrices components), and half of the time I have to wait for these accidental refresh to finish.
From a designer's view, Power BI desktop should maintain MINIMUM refresh i.e. include a manual refresh option.
If you think this should be improved, please vote here. I'm not the original author but this one already got 5 votes and is basically asking the same thing:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20228596-pause-auto-refresh
HI @markus_zhang ,
AFAIK, measures recalculated every time row/visual contents changed. If you mean disable measure recalculation when refresh progressing for reduce workflow and increase refresh performance?
If this is a case, current power bi allow your to enable apply button on slicer/filter to confirm their effect and interaction, but it not support do this on measure.
Regards,
Xiaoxin Sheng
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |