Forum Discussion

Spigaw's avatar
Spigaw
Icon for Helper III rankHelper III
5 years ago
Solved

Decimals automatically rounded

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. I...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    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.

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
5 years ago

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.