Skip to main content
Microsoft Idea

Power BI

Under Review

PowerQuery - UI option to temporarily suspend a step

Vote (53) Share
's profile image

on 12 Apr 2016 22:30:16

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)
's profile image Profile Picture

Power BI User on 16 Aug 2020 03:56:31

RE: PowerQuery - UI option to temporarily suspend a step

This would be a good feature to add.

's profile image Profile Picture

Mark sheffield on 16 Aug 2020 03:54:03

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.

's profile image Profile Picture

Colin Banfield on 16 Aug 2020 03:52:46

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.