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

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

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    So where are the columns coming from? Confused. Usually the source line actually references a source. Are you in the Query Errors when doing the View | Advanced Editor? You want to be on the original query when you do that.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      A table in an excel worksheet named 2016.

       

      • Abduvali's avatar
        Abduvali
        Skilled Sharer
        6 years ago

        Anonymous ,

         

        Go to Edit Queries and select your table with errors and on right side click on Navigation:

         

        And see if data is displayed as expected delete all steps below Navigation.

         

        Regards

        Abduvali