Start here
Lessons and reference
Look things up
Start here
SQL
Power Query
Data modeling
Power BI and DAX
Finance playbooks
Run queries
Build and check
Paste a Power Query M query and get every step explained in plain English, with reference links, folding hints and a re-indent button.
Press Explain this query to read each step. Hints about query folding appear here, with the step they belong to.
Paste the whole let ... in query from the Advanced Editor.
Every step gets a plain-English explanation with a link to its function.
Query folding hints point to the step that breaks it.
Power Query stores each transformation as a named step inside a let ... in block, separated by commas. The explainer finds the top-level let and in, then splits the steps at the commas that are not inside brackets, quotes or a nested let. Step names written as #"Changed Type" are read as one name, and comments are skipped.
For each step the explainer finds the first function call, such as Table.SelectRows, and gives a one-line plain description from a built-in list of 80 common functions. A link goes to the function reference page when that page exists. It also lists the earlier steps it uses and the text it mentions, such as column names.
The performance hints point at steps that often stop query folding. Folding means the database does the work, instead of Power Query pulling every row back. Buffering a table, adding an index column, sending your own SQL with Value.NativeQuery, and calling a custom function in a row step are the common cases. The hints use words such as "often" and "may" because folding depends on the source and the connector.
In Power Query Editor, open the Advanced Editor. It is on the Home tab in Power BI and on the View tab in Excel. Copy everything from let to the last line, and paste it here.
The step picks an item out of a record or a table, often a table from the source, such as Source{[Schema = "sales", Item = "orders"]}[Data]. It may also refer to an earlier step with no function.
Either the function is not in the reference yet, or it is a custom function written in this query. Only functions with a reference page get a link.
No. The explainer and the re-indent run in your browser. The page reads the list of function reference pages from this site, nothing else.
A small accounting query that loads orders and order lines from the classicmodels sample database, joins them, works out line revenue, groups it by month and removes cancelled orders. You can read it as a model for your own queries.
More tools: all tools · function reference · guides