power bi expression error changed type name

[abdalla]

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 

[Vijay_A_Verma]

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]

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 · Accepted solution]

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

[abdalla]

I tried tracing back the applied steps and i removed it and it worked thnx alot.

Really do appreciate your work sir. 

God bless