Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Getting DataFormat.Error: We couldn't convert to Number

I keep getting the error DataFormat.Error: We couldn't convert to Number. Details: UNK. The columns that I am getting these errors are set as text already. See below.     Thanks in advance! ...
Need Help
  • Abduvali's avatar
    Abduvali
    6 years ago
    Just delete step called Changed Type, I assume its there before you unpivot your columns.
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Can you post your M code? View | Advanced Editor or perhaps a screen shot of your steps?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Is this what you need?

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    So is 2016 a reference to another query?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      No that is the name of my query

      • Abduvali's avatar
        Abduvali
        Skilled Sharer
        6 years ago

        Hi Anonymous,

         

        Just check your previous steps on the right side in Edit Query mode.

        By default when data as loaded, power bi changes data types automatically so if you delete that step it might solve the problem. Alternatively click SOURCE on the right side and see if errors remains at loading stage or not. If yes then check the "#2016" table that you are referencing.

         

        Regards

        Abduvali