Forum Discussion
DataFormat.Error: We couldn't convert to Number. Details:...
Hola amigos, tengo un problema al momento de conectar datos del Power BI a un archivo Excel.
El archivo excel es una tabla de articulos, y tiene codigos numericos y alfanumericos, los codigos alfanumericos no los reconoce el Power BI. Ejemplo
Mi archivo excel
Como se muestra en el power BI
Por favor alguien que pueda ayudarme.
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
5 Replies
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 ZhangHi 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
