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.
1. Select that column before converting it to whole number
2. From the transform menu apply trim an clean
3. assign a default value to error occurence by using Replace Values> Replace Errors
MAAbdullah_47
Helper V
Helper VHi bukhari1979 sorry your solution is misleading and not correct.