Power Query practice exercises
418 graded exercises with sample data, 44 of them free with no account. Each one gives you a messy table, a goal and the expected result; you build the steps in the browser, and your query is checked against data it hasn't seen, so it has to work on refresh, not just on the sample.
The browser editor is laid out like Excel's Power Query editor, so the steps carry straight over; build your first query in Excel to see the same steps there. Prefer to practise in Excel or Power BI? Download the sample datasets or the practice packs.
Start with a free exercise
- beginner~10 minFree
Clean and summarize a sales export
Trim messy region names, keep valid completed orders, remove an exact duplicate and total revenue by region.
- beginner~7 minFree
Fix a query whose steps point at the wrong step (kite shop)
A step was renamed and the next step still refers to the old name. Repair the chain so the query runs.
- beginner~8 minFree
Reorder steps so cleaning happens before grouping (kite shop)
The query groups regions before cleaning them, so " north" and "North" are counted separately. Fix the step order.
- beginner~6 minFree
Remove a leftover step that cuts the data short (kite shop)
A Kept First Rows step left over from testing silently drops orders. Find it and remove it.
- beginner~5 minFree
Return the last step, not an earlier one (kite shop)
The query builds a Line Total column, but the result doesn't show it: the `in` clause returns an earlier step.
- intermediate~7 minFree
Fix a query that removes a column before using it (kite shop)
The query trims columns too early, so the Revenue step can't find UnitPrice. Reorder the steps.
- beginner~6 minFree
Fix a Changed Type step that breaks two columns (kite shop)
An automatic type step turned customer names into errors and stripped the zeros from order numbers.
- intermediate~6 minFree
Replace a hand-typed list of IDs with a rule (kite shop)
The query removes cancelled orders by listing this week's cancelled OrderIDs. Make it work every week.
- intermediate~7 minFree
Fix a step that silently skips the cleaning step (kite shop)
The query runs, but its totals are split across " north" and "North": the Group step reads Source instead of the cleaned step.
- beginner~7 minFree
Import a semicolon-separated stock file (hardware)
Read a CSV that uses semicolons, promote headers and set number types.
- beginner~7 minFree
Skip the title rows in a report export (consultancy)
The export starts with a report title and a blank line. Skip them, then promote the real headers.
- beginner~6 minFree
Import a CSV whose descriptions contain commas (hardware)
Some item descriptions contain commas and quote marks. Import the file so each description stays in one column.
Exercises by topic
Module 1
How Power Query thinks
Sources, previews and applied steps: why every transformation is a repeatable recipe.
25 exercises · 4 lessons
Module 2
Importing and inspecting data
CSV, table-like Excel sheets and JSON fixtures; headers, delimiters and encodings.
18 exercises · 4 lessons
Module 3
Data types, locale and nulls
Types, culture-aware conversion of numbers and dates, and the difference between null, blank and error.
21 exercises · 4 lessons
Module 4
Working with columns
Choose, remove, rename, reorder and duplicate columns, and keep queries stable when columns change.
21 exercises · 4 lessons
Module 5
Filtering and sorting rows
Filter by value, combine conditions, sort on several keys and keep top or bottom rows.
28 exercises · 4 lessons
Module 6
Text transformations
Trim, clean, change case, split, merge, extract and replace text with exact semantics.
24 exercises · 4 lessons
Module 7
Numbers, dates and conditional columns
Rounding, date parts, durations and conditional logic.
28 exercises · 4 lessons
Module 8
Profiling, errors and validation
Find and handle errors, missing fields and bad values with try … otherwise.
18 exercises · 4 lessons
Module 9
Duplicates and keys
Remove duplicates deliberately, choose the right row to keep and add index columns.
18 exercises · 4 lessons
Module 10
Fill down and report layouts
Fill down/up and turn report-style exports into tidy tables.
16 exercises · 4 lessons
Module 11
Appending tables
Stack tables, align schemas and handle mismatched columns.
17 exercises · 4 lessons
Module 12
Merging (joining) tables
Join kinds, composite keys, expanding results and predicting row counts.
20 exercises · 4 lessons
Module 13
Group by and aggregation
Summaries with sums, counts, averages and all-rows tables.
26 exercises · 4 lessons
Module 14
Pivot and unpivot
Reshape wide and long tables and survive new columns on refresh.
18 exercises · 4 lessons
Module 15
Combining files and parameters
Combine folder-like file packs with one reusable transformation.
17 exercises · 4 lessons
Module 16
M language basics
Values, let … in, records and lists.
21 exercises · 4 lessons
Module 17
Functions, each and scope
each, custom functions, branching and error handling in M.
21 exercises · 4 lessons
Module 18
Nested data and JSON
Expand records, lists and nested tables; flatten JSON.
18 exercises · 4 lessons
Module 19
Refresh robustness and performance concepts
Writing queries that survive new data, and what query folding and privacy levels mean.
21 exercises · 4 lessons
Module 20
Projects, debugging and interviews
Integrated projects, debugging workflows and interview practice.
22 exercises · 4 lessons