cancel
Showing results for 
Search instead for 
Did you mean: 

Power query connection - Decimals are lost

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

Status: New
Comments
v-chuncz-msft
Community Support
EddyBA
New Member

@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)

 

EddyBA_0-1621239498774.png

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

 

Thanks for your help.