Add, Rename columns in Power Query Source Data without breaking the query

[Shanna1230]

Hello, 

I've built a Query in excel for my department that compiles all the data from across four functions into a consolidated view. I want to be able to add, rename, and re-order columns in the source files without breaking my query. I would really appreciate your help on this one. 

Many thanks. 

[Ritaf1983 · Accepted solution]

Hi @Shanna1230 

Reordering columns doesn't break queries.

According to adding and renaming please refer to the linked videos :

https://www.youtube.com/watch?v=gJPA_Faotkk

https://www.youtube.com/watch?v=09tvia_8ykI

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly