Cancel Option when "Working On It"
Please provide a cancel button/option when a DAX calculated column is processing.
There are times when I create a calculated column, and the logic causes extremely long wait times for the column to evaluate on the table. My only option is to kill the background SSAS process or PBI Desktop, and reopen the report.
My tables are about 1-6 million rows.
Paul O'Connor commented
This is an absolute must have that really should have been there firstly.
Microsoft, if you push products, inevitably people will try and play with them. If they keep getting stuck as i do where i have to pray for the working on it to time out, it isnt going to be a worthwhile product.
People try different codes to do different things, so if there is no option to cancel the running query etc., loss of work and frustrations is all that will be achieved.
I am currently sitting here waiting for one so i dont lose work that has taken some working out to get done.
A real frustration to have to lose work due to the lack of a simple ability to cancel what you are doing.
john ridge commented
Additionally, it would seem very very useful to have
- a more general "stop all automatic calculations" option
- an ad-hoc "compute now" buttom
to allow a user to enter the DAX for multuiple new computed measures / columns etc.
The user coud then either signal to the system either :
a) press the "compute now" button
b) change the general setting back to "automatically compute"
Nuno Graca commented
Yes please!!! Qlikview has this function...
Yes this would be very beneficial
Alternatively when you know you have made a mistake on a measure, however need to wait to make the edit