Expand Nested Tables in Power Query M

Notes

Replace NestedColumn and the field list with your actual column and field names.

Requirements

• A table with a column whose values are themselves tables.

How to use this snippet

1. 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).
2. Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
3. Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

• Expand Nested JSON RecordsExpands a column of nested record values, common after parsing JSON from an API, into individual columns.
• Expand All Nested Columns DynamicallyDetects every record-type column in a table and expands all of them in one pass, without naming them individually.
• Add Index Column Within Each GroupAdds a sequential index that restarts at 1 for every group, instead of numbering the whole table.
• Rank Within GroupRanks rows within each group by a numeric column, highest value first.

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 Tables.