About Power Query Exercises
Power Query Exercises is a hands-on practice platform for Power Query and the M language, aimed first at Excel users, since that is where most people meet Power Query, and at Power BI users too. You work with realistic, fictional datasets, build transformation steps, read and edit the M they produce, and check that your solution still works when the source data changes. Today that means 80 lessons, 418 graded exercises, 35 guides, 40 function reference pages and 29 error explanations.
Who runs it
The site is built and operated by UMRATECH LLC, a company based in the United States. You can reach us at support@umratech.com. The terms, privacy policy and refund policy are published by UMRATECH LLC.
Who writes the lessons
Tahir Nas, software engineer, writes and reviews the lessons, guides and exercises. Tahir has 8 years of experience in tech, working across system administration, cloud architecture, QA, scripting and automation, and software engineering in many languages and mainstream databases. Find Tahir on GitHub.
How content is written and tested
- Every M example on a lesson, guide or reference page is run by our simulator when the site is built, and the output you see is that run's actual result. A build fails if an example stops producing its stated result.
- Every error page has two snippets that are checked on each build: one must raise the stated error, and the fix must run.
- Each graded exercise has a reference solution that must pass, and wrong solutions (a hard-coded result, an empty table, a query that only fits the visible sample) that must fail. Your query is checked against hidden datasets as well as the one you see.
- Lessons note where Excel, Power BI Desktop and the simulator behave differently, and anything the simulator can't run is labelled. The compatibility page lists what is supported.
- Every lesson says where its step is in Excel: the ribbon path in the Power Query editor, or a note that the step is written in M. Each path is checked against Microsoft's own documentation, which is cited next to it. The Excel guides show the whole editor.
- Pages show when they were published and last updated. If you find a mistake, email support@umratech.com; corrections are made in the content itself, not in a hidden note.
An independent practice simulator
Exercises run in an independently implemented educational simulator that supports a documented subset of M. It is not Microsoft's engine and does not replace Power Query in Excel or Power BI. When the simulator doesn't support a function or option, it says so instead of guessing. The goal is that you can repeat what you practised in a real Excel or Power BI host.
Independence
Power Query Exercises is an independent educational platform and is not affiliated with, endorsed by, sponsored by, or approved by Microsoft Corporation. All third-party trademarks belong to their respective owners.