Forum Discussion
column does not exist
Hi vat2do - you can check at the Applied Steps pane on the right of PQ editor. Review each step (especially early steps like Removed Columns, Renamed Columns, or Changed Type)- one of them is referencing the deleted columns.
Go to Home > Advanced Editor
You'll see the full M code for the query. Look for any mention of the missing columns and edit/remove accordingly.
When you find the step referencing missing columns:
Either delete the step, or Edit it to remove the reference to the missing column(s).
Hope this helps.
Hi vat2do
Check if there are any applied steps that are explicitly referencing the missing columns:
- changing data types
- selecting columns
- removing columns
- transforming columns
- additional columns that reference another column
In the example below, both the Measure Category and Sort columns are explicitly referenced. If either of these columns is removed or renamed in a previous step, or deleted from the data source, it will result in an error in the current step.