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.
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.
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
That seems to correct the errors. But when I unpivot my sales columns the errors return.
- Just delete step called Changed Type, I assume its there before you unpivot your columns.