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.
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?
Thanks for your idea.
Yes. I want Power BI desktop to just load in whatever is in the Excel file.
simply remove the last step that tries to delete column(s) (and any other steps that reference that column).
Do you mean delete this step marked with red box? please refer to the screenshot.
And delete fieds in the dashboard that reference that column.
Yes, if you remove that last step that you have in the red box, then it won't try to delete a nonexistent column.