Power Query Applied Steps
Learn how Power Query records transformation operations, manages Applied Steps, handles dependencies, and helps you troubleshoot data preparation problems.
Applied Steps is a list of operations recorded by Power Query
when you transform data. Each operation normally creates a
step that describes a change made to the query.
Examples include promoting headers, changing data types,
removing columns, filtering rows, renaming columns, and
creating calculated columns. Power Query uses these steps
as a repeatable transformation sequence.
Visual 1: A typical sequence of Applied Steps.
Visual 2: Simplified layout showing the Applied Steps pane.
Visual 3: Selecting a step displays the data at that stage.
Selecting a step allows you to inspect the data produced by that
operation. Some steps also provide a settings gear that lets you
modify the transformation.
Visual 4: A reliable workflow for reviewing transformation steps.
Use a meaningful step name to make complex queries easier
to understand. For example, a step named
Keep Valid Orders can be clearer than a
generic name such as Filtered Rows.
Use the step's context menu or available delete control.
Before deleting a step, check whether later steps depend
on the output it creates.
Reordering can change the meaning of a query. A step that
refers to a column created earlier may fail if moved before
the column-creation operation.
Visual 5: Later operations may depend on earlier steps.
Power Query uses the M language to describe data connections
and transformation operations. You can often inspect the
generated expression by selecting a step or opening the
Advanced Editor.
The following example demonstrates the general structure of
an M query. The exact step names and expressions depend on
your source data and transformations.
Assume your sales dataset contains Product, Region, Quantity,
UnitPrice, and OrderDate. Create a sequence of transformations
to prepare the dataset for reporting.
Confirm that the TotalRevenue values are numeric and that the
Applied Steps list reflects the transformation sequence.
Question 1: What is the purpose of Applied Steps? A. To change report themes B. To record query transformations C. To publish reports D. To create dashboard pages Question 2: What should you do after editing a step? A. Delete the source file B. Ignore later steps C. Inspect the output and verify dependent steps D. Close Power BI immediately Question 3: Why can reordering steps cause errors? A. Later steps may depend on earlier transformations B. It always changes the report theme C. It removes every data source D. It changes the operating system Question 4: What is a useful way to investigate a query error? A. Delete every step B. Publish without checking C. Inspect the earliest step where the output becomes incorrect D. Change all columns to text
1. Introduction to Applied Steps
Why Are Applied Steps Important?
2. Where to Find Applied Steps
3. Common Applied Steps
Step Name
Purpose
Example
Source
Connects to the original data source.
Connect to an Excel workbook.
Navigation
Selects a table, worksheet, or other source object.
Select the Sales worksheet.
Promoted Headers
Uses the first row as column names.
Column1 becomes Product.
Changed Type
Sets the data type of selected columns.
Revenue becomes Decimal Number.
Filtered Rows
Keeps rows matching specified conditions.
Keep records for the current year.
Removed Columns
Removes unnecessary columns.
Remove an unused comment field.
Renamed Columns
Changes column names.
CustName becomes Customer Name.
Added Custom
Creates a column using a formula.
Calculate Quantity multiplied by UnitPrice.
4. Inspect and Edit Applied Steps
5. Rename, Delete, and Reorder Steps
Rename a Step
Delete a Step
Reorder a Step
6. Understanding Step Errors
Problem
Possible Cause
Suggested Solution
Column not found
A column was renamed or removed earlier.
Check the column references in the affected step.
Data conversion error
Values do not match the selected data type.
Inspect invalid values and select the correct type.
Unexpected row count
A filter or grouping operation changed the result.
Review the relevant step and its conditions.
Source error
The source path, permissions, or source structure changed.
Check the connection and source availability.
Expression error
A formula references invalid names or values.
Review the expression and its input columns.
7. Understanding Power Query M Code
8. Practical Exercise: Sales Data
Practice Tasks
Expected Calculation
Product
Quantity
UnitPrice
TotalRevenue
Laptop
4
125.50
502.00
Monitor
3
200.00
600.00
Keyboard
5
25.00
125.00
9. Knowledge Check
View Answers
Summary
Applied Steps records the sequence of Power Query transformations.
Selecting a step helps you inspect intermediate data.
Some steps can be edited, renamed, deleted, or reordered.
Changing one step may affect later operations.
M code describes the underlying transformation logic.
Always validate the final result before loading the data.
You have completed the lesson on Power Query Applied Steps. Continue practicing with real datasets to improve your transformation and troubleshooting skills.