Forum Discussion

vat2do's avatar
vat2do
Helper III
1 year ago
Solved

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 versio...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    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.

     

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

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.