Column removal problem

[mscantle]

I removed a column in the Table View from a table called 'Headlines' which I no longer need. I also removed the corresponding column from the source spreadsheet in Excel. Now I get an error when I refresh the data saying that the missing column wasn't found. How can I solve this?

[ryan_mayu · Accepted solution]

you deleted it in the Table view, however, it is still in the Power query.

you need to go to transform data

you may find there is an error. 

you can delete the corresponding part in the M language

or delete the change type step and change type again.

[mscantle]

Thanks - that solved it!

[ryan_mayu]

you are welcome