Power QueryExercises

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

Related terms