Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Working with Column Headers in Power Query



When I work in Power Query on one of the sheets that I loaded from another excel workbooks I do some manipulation. 


Unpivot, Reorder and some other functions. In the end if someone will change one of the columns headers in my workbook all my work will be wasted since in my steps in power query when I checked, I saw that all the manipulation I did in Advance editor are using Column Names . 


Is there any other opthion to make the steps (re order, unpivot, etc.) withou using column name?



Community Champion
Community Champion

There are possibilities to adjust your queries in such a way that they will still work if columns are not the same each time.


But it requires some in-depth Power Query knowledge.

Gil Raviv blogged about a series of 10 pitfalls in Power BI / Power Query.
Several of those pitfalls are related to hard coded column names (especially from pitfall #4 and up).


Maybe you can use a solution I provided in another topic to rename columns by position.
So if you include such a rename in the beginning of your query/ies, then you can use that column names in the rest of your code.

As a prerequisite for this solution: the number of columns must not change.


Specializing in Power Query Formula Language (M)

Another cross post.

Specializing in Power Query Formula Language (M)

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!


Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors