Forum Discussion
Removed column from table and now getting error
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.
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.
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!