Power Query Problems

How to Fix Power Query Tutorial Errors When Removing Columns

Emma BrownEmma Brown Nov 2, 2026 870 views

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.

How to Fix Power Query Tutorial Errors When Removing 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.
Before you start

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.

Solution 1Recommended

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.

1
Verify your Excel version

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.

2
Modify the Removed Columns step

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.

3
Extract the year from OrderDate

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.

4
Find alternative resources

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.

Use an Updated Power Query Tutorial or Adjust Applied Steps
Understanding Query Dependencies: Always remember that deleting or renaming a column will break any subsequent step that relies on that specific column's exact original name.
Free Microsoft Office alternative

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. 1. Download and Install: Get WPS Office from the official website and install the lightweight package on your computer.
  2. 2. Open your Excel dataset: Launch WPS Spreadsheet and open your .xlsx or .csv sample file to begin data analysis natively.
  3. 3. Format dates instantly: Select your date column, right-click to choose 'Format Cells', and easily extract or display years without complex queries.
Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formats.Intuitive data filtering, sorting, and pivot table features.Free and lightweight alternative to heavy Microsoft 365 installations.Easy-to-use text-to-columns and date formatting tools.
microsoft office alternative - wps office

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.