Forum Discussion

giovanni_figuei's avatar
giovanni_figuei
Frequent Visitor
4 years ago
Solved

Error when importing spreadsheet from excel

Good morning.

Im trying to import a spreadsheet from excel to Power BI but im getting this error in some cells of a determined column:

DataFormat.Error: We couldn't convert to numbers.

The column has ID codes wich some of them are made of letters and numbers and others made of just numbers the problematics one are the ones made of letters and numbers, i have tried to convert the whole column to text both in excel and power bi and nothing changed.
Heres the problematic column and the type of data im dealing with 


 

 

 

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    giovanni_figuei , Once power bi load data, In Power Query(Data transformation) there will step where it does type conversion. Click on that step and change the data type to text. if it asks to overwrite the step do that. So that it never become number

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    giovanni_figuei , Once power bi load data, In Power Query(Data transformation) there will step where it does type conversion. Click on that step and change the data type to text. if it asks to overwrite the step do that. So that it never become number