Forum Discussion
Remove columns in source data Excel file
Yes, if you remove that last step that you have in the red box, then it won't try to delete a nonexistent column.
Anonymous
Thanks for your reply. I get your meaning and I am sure it works.
But I prefer to resolve it in the direct way. In future you can not prevent updating from source data. what should I do if source data column is missing like this? I cann't choose a product without function to deal with this senario.
What do you mean "resolve it in the direct way"?
Anonymous's suggestion is the simplest way to prevent extra columns appearing in the future by choosing what columns to keep rather than what columns to remove.
If you want Power BI desktop to just load in whatever is in the Excel file, then simply remove the last step that tries to delete column(s) (and any other steps that reference that column).
If neither of these work for you, then you need to explain more clearly how you want the load to behave. Do you always want every column from the Excel file or do you always want just a specific subset or some other logic that you haven't specified?