In Powerquery, when I want to temporarily remove a step, I can either:
1. Delete the step, then test without it, then recreate it
Or
2. Manually modify he M code by putting // and then resetting the names manually.
I would appreciate a quick way to suspend a step in the UI - something like there is in vba
Administrator on 16 Aug 2020 02:15:34
Thanks for the feedback! Sounds like a great feature for us to consider... Does anyone else find this option useful? if so, please vote.
- Comments (3)
RE: PowerQuery - UI option to temporarily suspend a step
This would be a good feature to add.
RE: PowerQuery - UI option to temporarily suspend a step
In testing a scenario and data import I wanted to be able to create a step and refine my syntax, what I had was wrong and yet I didn't want to lose it I really wanted a 'step over this ' kind of option whilst refining a different way of doing things, I can copy the whole process and then paste stuff back in but its messy, the lack of 'undo' and lack of 'step over' is a pain would really like a version control so after making a mess of the process I can go back to an earlier version.
RE: PowerQuery - UI option to temporarily suspend a step
This request sounds similar to a feature that I once requested. In my case, I'd like to select a step that is eagerly executed. When testing a particularly complex script, currently you have to change the step name in the "in" portion of the script to test up to the step name.
However, this a troubleshooting request, and it's not something I expect to see before a true scripting editor is implemented in M.