Forum Discussion
Solved
Dataformat.Error: We couldn't convert to Number
DataFormat.Error: Não foi possível converter para Number. Detalhes: 010002-1 I just keep getting the error with this tipe of number
Not sure what your question is.
That error, without knowing any spanish, I'm guess says it can't convert the format ####-# to a number.
Depending on what results you neeed a couple of options -
Keep it as text
Somehow format the column to get rid of the dash and then format as number
How do i solve it?
ibarrau
Super User
Super UserHi.
The error is caused because you have a "- " on the field (010002- 1). Power Bi cannot convert that cell to number. You should take an action to solve this. For example, you can split the cell on two columns separated by "- ". Then you can convert to number.
The convertion depends on what are you looking for this column.
Regards,