Expand Nested JSON Records in Power Query M

Expands a column of nested record values, common after parsing JSON from an API, into individual columns.

API & Web DataBeginnerjsonnestedexpandrecord

Power Query M code

let
    Source = YourTable,
    ExpandedRecord = Table.ExpandRecordColumn(Source, "NestedRecordColumn", {"Field1", "Field2"}, {"Field1", "Field2"})
in
    ExpandedRecord

Tidy JSON with the JSON Formatter

Notes

Use Table.ExpandRecordColumn for record-type columns (typical of parsed JSON objects); use Table.ExpandTableColumn instead for columns that hold nested tables.

Requirements

A table with a column whose values are records, such as from Json.Document.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Expand Nested JSON Records.