Power query connection - Decimals are lost

[EddyBA]

Dear community,

I have connected one excel file to others files with the power query connection. I don't know why but I am loosing all numbers after the comma.

Is there a way to keep them ?

Thank you in advance.

BR

[v-chuncz-msft]

@EddyBA 

You may open Advanced Editor and check the data type.

https://community.powerbi.com/t5/Desktop/Decimal-numbers-from-Excel-automatically-getting-rounded-an...

[EddyBA]

@v-chuncz-msftI did not find the "Int64.Type" mentionned in the link, i guess it has been replaced by "number", right ? (see my script as below)

@amitchandak added as you have answered to a similar topic, but the proposed solution doesnt' work for me.

Thanks for your help.