Power QueryExercises

Record

A set of named fields, written [Name = "Ana", Age = 31]. A table row is a record, and JSON objects become records.

Fields are read with [Field] and optional fields with [Field]?, which returns null instead of an error when the field is missing. Records can be combined with &, and Record.FieldNames lists their fields. Nested JSON objects arrive as record columns that you expand.

In the Power Query editor

A record column shows the word Record in each cell; the expand icon in its header turns fields into columns.

Learn more

Practise it

Related terms