Forum Discussion

zraopingm's avatar
zraopingm
Icon for Helper IV rankHelper IV
2 years ago

error after removing columns from data source

hi I originally import data source from excel into Power query without convert it into table  i further removing a few columns from excel file, got error message upon refeshing in power query i wou...
Need Help
zraopingm's avatar
zraopingm
Icon for Helper IV rankHelper IV
2 years ago

Thank you Greg, 

that was exactly what it is.. but is there a way to automate this? i.e. if i remove a column A with previous steps ( say changing type), subsequently remove column A from source file, will Power query simply just recognize no such column as A once i refresh it? 

thank you

Zoey