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.
Hi ikhwan_tokenomy and Greg_Deckler - I am experiencing exactly the same problem with a Postgres connection data import. Also dealing with a decimal number with a large amount of digits after the 'dot'. Also getting the error message "DataSource.Error: An error happened while reading data from the provider: 'Numeric value does not fit in a System.Decimal". Did you find a way to deal with this?