I have inherited an existing Query (I am s new user) so limted knowledge. Source data owner has changed a column name !

[Beth369]

Hi all,

Thanks in advance for reading this. I am a very new user trying to learn more about using Power Query. I'm in a new role and was handed over an exiting power query xls that uses data from another xls. The source comes in xls format from an external vendor. They recently changed one of the colum names but never told us. I was given the task of 'fixing this'.

Looking into it, there seems theres so much to learn. I would really appreciate some help on the best way to do this?

 

[RoryA]

When you select a cell in the table, do you see these tabs on the right hand side of the ribbon?

 

[Beth369]

Hello, yes I can see them

 

[Automatrix]

You can open the query in the advanced editor and look for "SPO Name" in the code, then change it to the new name.

 

[RoryA]

On the Query tab you should see an Edit button. Click that to open the PQ editor. On the left hand side will be a list of all the queries in the workbook (hopefully only one in your case!). Select the one of interest, and on the right hand side you should see the Applied Steps list - something like this:

The error almost certainly won't be in the Source step, but select each step below that in turn until you see a yellow error message in the middle section - e.g.:

Somewhere in the formula in the formula bar at the top, you will find a reference to the column that is now missing/renamed. Either remove it, or change it, as applicable and then press the tick mark on the left of the formula bar. Then move through the rest of the steps, checking for errors until you get to the final step. Hopefully all will now be fixed!