Forum Discussion
ikhwan_tokenomy
4 years agoFrequent Visitor
Handling large decimal number
Hi PowerBI Community I am dealing with large decimal number. and receive this error message. " DataSource.Error: An error happened while reading data from the provider: 'Numeric value does not f...
- 4 years ago
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.
Greg_Deckler
4 years agoCommunity Champion
ikhwan_tokenomy That's a new one, just how big is this number?