column does not exist

[vat2do]

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.

[danextian]

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.

[rajendraongole1 · Accepted solution]

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.