Decimals automatically rounded

[Spigaw]

Hi there,

The screenshot I join to this thread is self-explanatory: I have values with a lot of decimales, but even when defining the value type as float, Power Query rounds the figures.

Is there a way to stop it doing that? I tried adding figures after the comma, but to no avail.

Thanks for your help.

[v-jingzhang · Accepted solution]

Hi @Spigaw 

It is because the decimal number has reached the limitation of the format. The larget precision that can be represented in a Decimal Number type is 15 digits long. See Data types in Power Query | Microsoft Docs

If you want to show them completely, you can change the column to Text data type.

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[lbendlin]

Great question. You can change the format to "Fixed Decimal Number" but that may not be good enough for you.

Keep in mind that float and decimal formats are approximations of the original value. There's no guarantee for a true match.