Forum Discussion

delgadomk's avatar
delgadomk
Regular Visitor
9 years ago
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...
Need Help
  • delgadomk's avatar
    delgadomk
    9 years ago
    Thank you! I made the changes to the excel file first then made them again in the Desktop and it seems to have worked.
Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

delgadomk

 

Hi, In Edit Query, Change the DataType to Text

 

 

 

Close & Apply.

Franz_Valverde's avatar
Franz_Valverde
Frequent Visitor
9 years ago

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?