Forum Discussion
column does not exist
Hi Experts,
I have created PBi report based on excel having 19 different columns, now the excel file is reduced to 9 columns. My report is based on those 9 columns which are common in both versions so i have no issue about data, but
when i am trying to refresh the report it gives error that "column doesnot exists".
Any solution to this ? i would be greatful with thanks.
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.
2 Replies
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.
