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,
I've had the same problem.
Using data with number format ( 1,233.331), and use it in a Dutch PowerBi.
The solution for me was to change the datatype from text to decimal based on country codes, in Query-editor. That is the last option in the menu when you click on the datatype symbol in the column header. Choose datatype decimal, Country English (world).