Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 fit in a System.Decimal'
"
is there a way to fix this in power query? I don't want to exclude the data, I need to include them still. preferably not by reducing the decimal from the source
Thank you
Solved! Go to Solution.
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?
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.
@ikhwan_tokenomy That's a new one, just how big is this number?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
52 | |
21 | |
12 | |
11 |