Forum Discussion
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! ...
- Just delete step called Changed Type, I assume its there before you unpivot your columns.
Is this what you need?
So is 2016 a reference to another query?
No that is the name of my query
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
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.
A table in an excel worksheet named 2016.