cyfairmedicalpa's avatar
cyfairmedicalpa
New Member
9 years ago
Status:
Needs Votes

Disable Step (Comment Out) within GUI

It would be very helpful if there was an option to right click on a step from within the Power Query GUI and "disable" it (which behind the scenes would really just comment out that line and change the next line's table references automatically). The reason it is helpful is if I am wanting to test how deleting a step would affect the query, I have no way to do it except either proceeding with the delete (and remember there is no undo option) or manually going into the edit, commenting it out, and changing the reference).

6 Comments

  • I agree with this feature request and am surprised it doesn't exist already. Here's my similar write up of the request:


    When using the Power Query editor I would like to see an additional option in the Steps right-click menu to allow me to Comment or Uncomment a step. When debugging I often create filters and I'd like to be able to easily turn them on or off. Commenting a step would use the same logic as your Delete command by updating any referencing steps to refer to the step above, but instead of removing the step it would prefix it with //.  

     

    You could make the prefix include another character like "//!" so it could discern between commented steps and regular comments. Commented steps with the special prefix could still show in the Steps panel but with distinct formatting (green font, italics, etc.). The developer could right-click on a commented step to restore it.  The assumption would have to be that any references to the step above would now point to the restored step.

     

    Vote for this if you think it would save you time troubleshooting your queries. 

  • Vital suggestion, and this idea is suggested many, many times. The votes should be combined.

  • Oh yes, and further, the GUI should preserve all comments and white space choices. How absurd to have comment and formatting that I chose for readability purposes just wiped out. Documentation should be considered a much higher priority, including indent and spacing choices, especially in a language with such long statements. Thank you.

  • This is a great suggestion. Essentially, being able to toggle steps on/off in Power Query would enable modelers to not only debug queries - but to quickly manipulate them for ad hoc purposes while preserving established work. The example given to toggle filters on and off is a use case I run into constantly during semantic model tuning and validation.

Recent ideas