Forum Discussion
Solved
Error - DataFormat.Error: We couldn't convert to Number. Details J7510
Hi, I keep receiving an error when I import my excel file into PowerBI Desktop. I think what is happening is that in some of the fields, there is a comma. For example, I have a column titled Pr...
- Thank you! I made the changes to the excel file first then made them again in the Desktop and it seems to have worked.
Hi Kim,
When you are importing the data from excel to Power BI, the program automatically identifies certain columns and converts them to number. However, this step may lead to some erros, exaclty what is happening to you with your data.
If you noticed, when you import the data, in the "Applied Steps"section, the third step is "Changed Type" - this is an automatic data conversion step. To solve your problem simply remove this step and then you can convert to text whithout any errors.
I hope this helps you.
Best Regards,
João Silva.
JoaoSilva77 Your contribution is late and doesn't make sense as the data comes from a website and the objective is to convert the values to integers.
