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
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

zraopingm I would recommend opening your query in Advanced Editor and searching for the removed column names. They are probably referenced in a "Changed Type" step at least. Remove the references to the removed columns and you should be OK.