Power QueryExercises

Combine files that each start with banner lines (bakery)

Every export starts with two banner lines before the header. Write one transform for a file and apply it to all of them.

Level
advanced
Time
~12 min
Task
Build the query
Access
Pro
Checking your access…

About this exercise

What you'll practise

Turn a sample-file transformation into a function and apply it to every file in a folder.

The scenario, sample data, step list, hints and solution open with Pro. Grading checks your query against hidden data as well as the visible sample, so a query that only fits the sample doesn't pass.

Input

  • OrdersFolder (folder)
    • Columns: Content (binary), Name, Extension, Date modified, Folder Path
    • File orders-2026-01.csv
    • File orders-2026-02.csv

Expected output columns

Source.Name (text), OrderID (text), Customer (text), Qty (number)