DataFormat.Error: We couldn't convert to Number. Details:...

[RenaCel]

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.

[Anonymous]

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

[RenaCel]

Hi Lydia, The problem is when in a column has numerical and alphanumerical data. Attachment test file File

Thanks.

Renatto

[Anonymous · Accepted solution]

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

[Anonymous]

This solution is the correct! Thank a lot 

[RenaCel]

Hi Lydia, thanks!!!