Allow to disable the auto-compile for every DAX change in Power Pivot
The DAX compiler takes more than a minute to re-compile the model each time I modify the DAX code, or if I change the datatype of a measure.
This is with "Manual Calculation Mode" set, which if not set would take even more time.
Sometimes, I need to change many measures in a batch way and it is very painful to have to wait a good 1 minute between each changes.
A way to pause the compiler and modify many measure would be such help.
Currently, I have about 1000 measures. Assuming I would like to beautify them (code indentation) this would take me days waiting for the compiler between each change.
Kenneth Barber commented
I use OLAP PivotTable Extensions to disable the automatic refresh:
Denis Kostin commented
I support! With the increase in the number of measures, the issue becomes very urgent. We need a mechanism like deferred updating of the PivotTable in the part of recompiling the model.
Agree! We really need this! All Excel users indeed!
We really need this!