Forum Discussion
Handling large decimal number
It only shows 9 digits in the table but it maintains precision to about 15 significant figures.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-types
Fixed Decimals and Whole Numbers can express up to 19 digits of significance but aren't a good fit for the example given. For 20+ significant digits, you'd have to store them as text or break them into multiple columns.
for example the number is
0.0004198058911676167080085202
data source is postgre, field data type is numeric
Greg_Deckler
ikhwan_tokenomy I don't have Postgres to test with but I imported from a CSV file and it imports OK. However, when converting to decimal number it only has a decimal precision of 9 as shown in Power Query. However, once it loads into the table it has 19. Seems like the only way to preserve it would be to have it be Text.
It only shows 9 digits in the table but it maintains precision to about 15 significant figures.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-types
Fixed Decimals and Whole Numbers can express up to 19 digits of significance but aren't a good fit for the example given. For 20+ significant digits, you'd have to store them as text or break them into multiple columns.
Thanks AlexisOlson & Greg_Deckler for your response