Forum Discussion
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 c...
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 , 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
Thanks, you helped me a lot.