Excel can not read decimal numbers

[Anonymous]

I have to import a excel file to refresh it daily.

The problem is that it can not import rows with decimals (in spain we use comma for decimal).

This is original excel:

This is import result on power bi:

It must be a excel format problem because if I open excel and save it (with no change), then power bi can import it correctly.

Any help?

[Greg_Deckler]

@Anonymous Have you tried inserting a step in Power Query editor where you change type using locale?

[Anonymous]

Hi @Greg_Deckler,

As you can see on image data is not loading from beginig an it is cast as text.

is it posible to check errors on load?

[v-easonf-msft]

Hi, @Anonymous 

You can consider replacing all "," with  "." before converting the data type.

Best Regards,
Community Support Team _ Eason

[StefanoGrimaldi]

can you show the power query steps and m code u using? what can happend its that its reading the decimal value as a text value and returning null as consecuence of the error its a expted behavior, on the query editor you can set the column type by clicking right click on the header go to the options that says "using locale" there will let you select a data type and specify the region data type its coming from, that will make it to recognize the coma as decimal separator if the selected locale use it as that, 

also you need to apply that type changed before the one you have right now o replace the one you have with it, 

if this helped give some kudos, and mark as solutions for others to find

[Anonymous]

Hi @StefanoGrimaldi,

As you can see on image data is not loading from beginig an it is cast as text.

is it posible to check errors on load?

[StefanoGrimaldi]

i fthe excel data its on a table, change that column type to number and reload.