Forum Discussion

RenaCel's avatar
RenaCel
New Member
9 years ago
Solved

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 alfanu...
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

RenaCel's avatar
RenaCel
New Member
9 years ago

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

 

Thanks.

Renatto

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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