Power Query Editor Overview

Power BI · Power Query (Data Transformation)

Theory

Power Query Editor is where you clean and reshape data before it loads into the model. You open it with Home → Transform data. The left side lists queries (one per table), the centre previews the current table, the ribbon holds transformations, and the Query Settings pane on the right shows Properties and the list of Applied Steps.

Every click you make, such as removing a column, filtering rows or changing a type, is recorded as a step written in the M language. On each refresh Power BI replays those steps in order against fresh source data, so the cleaning is fully repeatable. For example, a Sales query might read Source → Promoted Headers → Changed Type → Filtered Rows → Removed Other Columns. You can click any earlier step to see the data at that point, rename steps, or delete one.

Why we use it

Raw data is rarely report-ready: wrong types, extra columns, messy text. Power Query fixes it once with recorded steps instead of manual edits that must be repeated every month.

When to use it

Use Power Query for row and column shaping: types, filters, splits, merges, unpivots. Use DAX for calculations that depend on report filters. If the same cleaning is needed by many tools, consider doing it upstream in the database.

How it works

  1. Home → Transform data
  2. Select a query in the Queries pane
  3. Apply a transformation from the ribbon
  4. A new step appears in Applied Steps
  5. Is the table report-ready? Yes: Close & Apply to load the model. No: Add or fix another step.
  6. Steps replay on every refresh

Syntax

Open: Home → Transform data
Ribbon tabs: Home | Transform | Add Column | View
Right pane: Query Settings → Applied Steps
Finish: Home → Close & Apply
View → Advanced Editor (see the full M script)

Example

Applied Steps for the Sales query:
1. Source            - connect to sales.csv
2. Promoted Headers  - first row becomes column names
3. Changed Type      - OrderID, Qty, Amount → Whole Number; OrderDate → Date
4. Filtered Rows     - keep OrderDate in 2024
5. Removed Other Columns - keep only the 7 model columns
Close & Apply → the cleaned Sales table loads into the model.

Key points

Power BI topics

Power BI Introduction

Getting Data

Power Query (Data Transformation)

Data Modeling

DAX (Data Analysis Expressions)

Data Visualization

Dashboards & Reports

Power BI Service

Advanced Features

Projects & Case Studies

Interview & Certification

Advanced DAX & Time Intelligence

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Power BI Dashboards & DAX

Learn data visualization and interactive dashboards step-by-step. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice DAX Online 250 business scenarios on a star schema — write a measure and compare your visual with the expected one. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Power BI  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax / Where to find it
{{ current.syntax }}
Example
{{ current.example }}
What You'll Learn — click to check off
  • {{ pt.mark }} {{ pt.text }}

Share this topic