Table
Rows of records sharing the same columns. Most Power Query steps take a table and return a table.
Every row of a table is a record with the same fields, and every column can have a type. Table functions don't change a table in place: they return a new table, which the next step takes as input. #table(columns, rows) builds a small table by hand for testing.
In the Power Query editor
The data preview grid in the editor shows the table produced by the selected step.
Learn more
Practise it
- 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~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.
- 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.