Forum Discussion

olander's avatar
olander
Frequent Visitor
3 years ago

Column name doesn’t update in subsequent Power Query steps

Hello,   I’ve written a many-step query, and now I want to rename a column from an early step. When I do, any subsequent steps that reference this column break. I’m surprised that it doesn’t update...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi olander ,

Please try Table.RenameColumns().

For more details, you can read related document: Table.RenameColumns - PowerQuery M | Microsoft Learn

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

olander's avatar
olander
Frequent Visitor
3 years ago

Thanks for your replies. Unfortunately, you are still not answering my question. Table.RenameColumns is only guaranteed not to break a query if it is used before adding any additional steps.

 

In my case, I have a query with multiple steps, and I would like to go to an early step (say where I created a column) and rename a column. The column I wish to rename is referenced several times in subsequent steps. When I rename the column, those steps break. They are still using the old name. How can I repair those steps while keeping the earlier column name change?

 

Thank you