Forum Discussion

abdalla's avatar
abdalla
Helper I
4 years ago
Solved

power bi expression error changed type name

Hello guys,

My issue here is that im working on power bi with maps and tables showing different points on a map with values etc...

The main file that im using had an extra column that i didnt need and hence i deleted it 

This column is "Row" which i named but unfortunately i forgot to use the power query in the power bi to delete it 1st so i open the advanced editor and tried inputting it so that it accepts it but i keep getting this error

I would be grateful if anyone can help me understand and resolve this situation 

Thank you 

  • Remove this complete line - #"Removed Columns"
    In #"Filtered Rows" line, replace #"Removed Columns" with #"Promoted Headers"

4 Replies

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional

    Replace #"Changed Type" with #"Promoted Headers" which is the previous step. #Changed Type" step is not existing anymore in your query.You need to make this replacement in line starting with #"Removed Columns" after Table.RemoveColumns.

    • abdalla's avatar
      abdalla
      Helper I

      Hello,

      1st of all Thank you for replying i appreciate it and i tried your solution but still a no go, it still says that the column is not found 

       

      • Vijay_A_Verma's avatar
        Vijay_A_Verma
        Most Valuable Professional

        Remove this complete line - #"Removed Columns"
        In #"Filtered Rows" line, replace #"Removed Columns" with #"Promoted Headers"