Forum Discussion
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_VermaMost 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.
- abdallaHelper 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_VermaMost Valuable Professional
Remove this complete line - #"Removed Columns"
In #"Filtered Rows" line, replace #"Removed Columns" with #"Promoted Headers"