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