Delete Steps Until End In Power Query

Power Query lets you perform a series of steps to transform your messy Excel data. And if you make a mistake, it’s very easy to Delete Steps Until the End!

Let’s say you’re deep in thought, creating multiple steps, then all of a sudden you realized midway some of the steps were incorrect.

Our sample Power Query steps removes rows from our table, and we want to undo those steps!

Let’s go through the steps in detail:

download excel workbook Delete-Steps-Until-End.xlsx

STEP 1: Let us edit an existing query that we want to modify.

Go to Data > Get & Transform > Show Queries

Double click on your Query to open the Power Query Editor.

STEP 2: We want to remove all of the Removal steps in our Query. So we will be deleting Step #3 onwards:

Right click on the Step #3 and select Delete Until End.

STEP 3:  Click Delete.

The steps are removed, and you can see your data is now restored!

How to Delete Steps Until End in Power Query

Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.