Removed column from table and now getting error

[ChrisAZ]

I am unclear on how I can remove a column from a CSV source file location without getting this error? I know it is looking for that column based on my initial import, but what is the process for adjusting this if I need to remove a column after the fact without deleting the data source and having to set it up for import all over again? This could cause all my relationships and everything else to have to be recreated.

[anilelmastasi · Accepted solution]

Hi @ChrisAZ ,

1. Open Power Query Editor
In Power BI Desktop, go to Home → Click Transform Data (to open Power Query Editor).
Find the query that loads your CSV file.
2. Identify and Remove the Broken Step
In Power Query Editor, check the Applied Steps pane on the right.
Look for the step where the missing column was referenced (likely under "Changed Type", "Removed Columns", or "Renamed Columns").
Click on that step—Power BI will show an error like "The column Operator was not found".

Either remove that step or modify it to exclude the missing column. (You can send the M code of that step, if you have still problem.)

3. Refresh the Query
Click Close & Apply to save the changes.
Try refreshing the dataset.

[ChrisAZ]

Thank you. I was able to get my input file set to match with the same column again for now so it is not giving that error, but I am hopeful this will be useful if/when I do run across this again as I feel like it is not that uncommon to have to adjust a column, remove, etc. from time to time, and I will be able to reference back to this if needed at that time!