Forum Discussion

mscantle's avatar
mscantle
Helper I
1 year ago
Solved

Column removal problem

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?

  • 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.

     

3 Replies

  • 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.