Forum Discussion
DataFormat.Error: We couldn't convert to Number. Details:...
Hi RenaCel,
I make a test using your sample file.
Firstly, when importing data from Excel to Power BI Desktop, please choose "Edit" in the following screenshot to load data.
Secondly, delete the "Change Type" step in "APPLIED STEPS" .
Thirdly, click "Close and Apply", you will be able to see that the data are imported properly into Data View.
Thanks,
Lydia Zhang
Hi RenaCel,
Firstly, this is English forum. Please help to post your question in English format.
Secondly, when do you get the above error message” We couldn't convert to Number”? Based on my test, there are no issues when importing your sample data to Power BI Desktop. However, if we try to convert the COD_ITEM column to numeric type column, the error message will occur, this is an expected behavior. We are not able to convert text-based string to number, but we can change text-based number columns from Text to numeric type.
Thanks,
Lydia Zhang
Hi Lydia, The problem is when in a column has numerical and alphanumerical data. Attachment test file File
Thanks.
Renatto
Hi RenaCel,
I make a test using your sample file.
Firstly, when importing data from Excel to Power BI Desktop, please choose "Edit" in the following screenshot to load data.
Secondly, delete the "Change Type" step in "APPLIED STEPS" .
Thirdly, click "Close and Apply", you will be able to see that the data are imported properly into Data View.
Thanks,
Lydia ZhangHi Lydia, thanks!!! :smileyvery-happy:
This solution is the correct! Thank a lot