Skip to main content

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

773b4324 a093-4509-a256-e74d11f79189 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

a5cd7a3f e1aa-42a8-8b56-889b84b0c840 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

38d2f369 2282-4a85-8865-c89694ce9111 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.