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.
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