Forum Discussion

abdalla's avatar
abdalla
Icon for Helper I rankHelper 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 ...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

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

Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

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
    Icon for Helper I rankHelper I
    4 years ago

    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
      Icon for Most Valuable Professional rankMost Valuable Professional
      4 years ago

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

      • abdalla's avatar
        abdalla
        Icon for Helper I rankHelper I
        4 years ago

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

        Really do appreciate your work sir. 

        God bless