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.
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