on 06 Jul 2016 20:08:26
Expanding columns in the Query Editor (with Transform->Structured Column->Expand) one-by-one with heavily nested Records and 100+ columns by the end is
incredibly tedious and time-consuming.
A single function to continuously expand all columns capable of being expanded until no more can be expanded would be useful.
Ideally this could have a check-box as well, setting the function to run every time data is updated to allow for evolving input schema.
Administrator on 29 Jun 2021 22:18:05
Updates have been made to Power Query with automatic table detection for nested fields and delivered in the April Desktop release, please feel free to submit a new idea if it pertains to a specific data source: https://powerquery.microsoft.com/en-us/blog/power-query-updates-in-power-bi-desktop-april-2021-release/
- Comments (2)
RE: Expand All Columns in Query Editor
For now you can use this script https://blog.crossjoin.co.uk/2014/05/21/expanding-all-columns-in-a-table-in-power-query/
RE: Expand All Columns in Query Editor
An example of when this would be useful, is when the names of the columns can change. For instance I have some parameters I can change to perform a different query, resulting in different column names, which breaks the query. I must edit the query manually to tell it which columns it needs to expand as the ones it previously was looking for aren't there.