How to Fix Power Query Tutorial Errors When Removing Columns
Question details
The user is following a Power Query tutorial but gets stuck when trying to transform an OrderDate into a year because previous steps removed the required columns.

- Product
- Excel Power Query
- Device & OS
- not provided
- Scenario
- Following a beginner tutorial for data transformation.
- Observed behavior
- The tutorial instructions fail at the date transformation step due to missing columns that were removed in earlier steps, likely due to outdated tutorial content.
Check the version of Excel you are using compared to the tutorial's published date, and ensure you have an unmodified copy of the sample data before restarting the steps.
Use an Updated Power Query Tutorial or Adjust Applied Steps
Microsoft's official tutorials are occasionally outdated compared to the current Excel 365 interface. Sourcing modern materials or modifying your Applied Steps prevents missing column errors.
Power Query records every action sequentially in the 'Applied Steps' pane. If a tutorial instructs you to delete a column in step 3, but then asks you to extract a year from that same column in step 6, the query will fail. Outdated tutorials or mismatched sample workbooks often cause these discrepancies.
Open Excel, go to File > Account, and check your version (e.g., Microsoft 365). Ensure your tutorial matches this specific version to avoid UI mismatches.
In the Power Query Editor, look at the 'Applied Steps' list on the right pane. Double-click the gear icon next to 'Removed Columns' and uncheck 'OrderDate' to keep it in your dataset.
With the OrderDate column restored, select the column, navigate to the Add Column tab on the ribbon, click Date > Year > Year to successfully transform the data.
If the tutorial remains out of sync, search for recent YouTube video tutorials covering 'Power Query Excel 365 date transformation' to see the updated workflow with current sample workbooks.

Simplify Your Data Analysis with WPS Office
Struggling with complex Power Query tutorials? For many everyday data transformation tasks, WPS Spreadsheet offers an intuitive interface without the steep learning curve. It is lightweight, free, and fully compatible with Microsoft Excel formats.
- 1. Download and Install: Get WPS Office from the official website and install the lightweight package on your computer.
- 2. Open your Excel dataset: Launch WPS Spreadsheet and open your .xlsx or .csv sample file to begin data analysis natively.
- 3. Format dates instantly: Select your date column, right-click to choose 'Format Cells', and easily extract or display years without complex queries.

Frequently Asked Questions
Why do I get a 'Column Not Found' error in Power Query?
This occurs when a step in your query tries to reference a column that was deleted, renamed, or not loaded in a previous step. You can fix this by reviewing the 'Applied Steps' pane and adjusting the sequence.
Can I retrieve columns I accidentally deleted in Power Query?
Yes. Go to the 'Applied Steps' list on the right side of the Power Query Editor. Click the gear icon next to the 'Removed Columns' step to modify it, or click the 'X' to delete the step entirely and restore your columns.
How do I extract a year from a date column correctly?
Select the date column (ensure it is formatted as Date), navigate to the 'Add Column' tab, click on 'Date', select 'Year', and then click 'Year' again. A new column containing just the year will be created.




