Save Applied steps in Power Query Editor

[PC20]

I work on several project simultaneously in development stage.

When data changes, some steps becomes invalid (For eg: Due to missing columns/renamed columns). Due to this, sometimes the steps (in Applied steps) gets deleted on Refresh, and I loose track of what was done.

Is there a way to save/store the Applied steps to keep a track on what I had done earlier?

For now, either I manually document it or save M-code to a text editor.

[v-jialluo-msft]

Hi  @PC20 ,

According to your description, your requirement is back up applied steps in Power Query Editor.

You can try to right-click on the last step and select "Extrac Previous", which will generate a backup table with all the previous application steps.

Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PC20]

@v-jialluo-msft I tried this, but it creates an extra query (Increased processing) with the previous steps.
And the original query has been modified to include only the Source and the last step, which is not my requirement.

I want to keep a track of what I have done without increasing the processing (like additional query for backup) or any modifications to my existing query.