Forum Discussion
valcat27
Helper III
Helper IIIError converting a text column (that contains only numbers) to number type
Hello all, I am importing a csv file with 5 columns and one of them has only decimal numbers between 0 and 1 but power BI import it as text type. I need it as number type, but when try to conv...
I did not find the problem but I tried to save my file in xlsx format and import it to power BI and it works, the column is recognized as number type.
valcat27Helper III
Helper IIII did not find the problem but I tried to save my file in xlsx format and import it to power BI and it works, the column is recognized as number type.