Forum Discussion
Error - DataFormat.Error: We couldn't convert to Number. Details J7510
- Thank you! I made the changes to the excel file first then made them again in the Desktop and it seems to have worked.
Typically, a step "Changed Type" is created when importing data from Excel.
You can adjust the generated code so your column will be changed to type text.
Thanks that worked for me. In advanded editor when selecting Changed Type and finding the field NAMEID it showed
... {"NAMEID", Int64.Type}, ....
Then I just changed it to
... {"NAMEID", type text}, ....
and it worked :smileyhappy:
This works for me too!
Thank you!
- Thank you! I made the changes to the excel file first then made them again in the Desktop and it seems to have worked.
Hello!
I have the same error when importing web data from: https://es.wikipedia.org/wiki/Copa_Am%C3%A9rica
Trying to convert the year that is a string data type to the Whole Number data type.
This error is only displayed in some cases (rows).
I copied the column Año (Year), to Año-Copy (Year-Copy) and aplyed Whole Number Conversion.
As taught in the Microsoft Virtual Academy course: https://mva.microsoft.com/en-US/training-courses/initiating-with-power-bi-16911?l=Zj9Ql9MED_2305192797
Any advice please?
- Thank you! It worked for me!
