Regular Visitor

5 years ago

Status:

New

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

2 Comments

v-chuncz-msft
Community Support
5 years ago
EddyBA

You may open Advanced Editor and check the data type.

https://community.powerbi.com/t5/Desktop/Decimal-numbers-from-Excel-automatically-getting-rounded-and/m-p/1087536#M503675
EddyBA
Regular Visitor
5 years ago
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.

Completed Ideas