Ben Sacherich on 04 Oct 2021 19:07:02
In the Applied Steps window, please give us the option to enable or disable a step. When debugging I often want to put in a filter to shorten the scope of records processed, and then comment that line when going live. I'd like to have a way to easily bring back that filter without having to manually edit the source of the following step.
This doesn't need to be limited to filters. I'd really like to be able to comment/uncomment any step. Instead of listing all commented steps, you could just list ones that were commented with a special prefix, such as //// or //!
The logic the editor is using when I Rename a step would be similar to what needs to happen here. Subsequent steps need to be updated to point to this new line when it is enabled, and the previous line when it is disabled.
- Comments (2)
RE: Allow Enabling/Disabling a step to help with debugging
Commented steps with the special prefix could still show in the Steps panel but with distinct formatting such as green font, italics, etc. The developer could right-click on a commented step as have a menu option to Uncomment it. The assumption would have to be that any references to the step above would now point to the restored step.
RE: Allow Enabling/Disabling a step to help with debugging
I don't think it was clear that I intended this as an idea for the Power Query interface in Power BI and Excel.