Power QueryExercises

Practice downloads

16 free packs of original, fictional data for practising in Excel or Power BI Desktop. Each pack has messy CSV, XLSX or JSON files, tested .pq queries and step-by-step follow-along instructions.

What you get, honestly labelled

  • Data files: plain CSV, JSON and XLSX. The XLSX files contain values only, with no formulas and no Power Query connection inside.
  • Queries: .pq text you paste into the Advanced Editor. The first lines explain how each source is bound to the files and which folder to change.
  • Each query was run in the Power Query Exercises simulator against the exact files in its pack. We haven't run them in Excel or Power BI, so these aren't ready-to-refresh workbooks.
  • CSV and XLSX files are protected against spreadsheet formula injection.