I didn’t realize reordering columns in Power Query could be so complicated. Thanks to Gil Raviv for his solution.
Posts Tagged → Table.ColumnNames
Rename Columns Based on Position
In Power Query I select columns based on their name, unpivot other columns and load the data into the data model. Later, if the source columns get renamed, I get an error when I refresh the query.