Error when importing spreadsheet from excel

[giovanni_figuei]

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 

 

[amitchandak · Accepted solution]

@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

[giovanni_figuei]

Thanks, you helped me a lot.