Forum Discussion
Anonymous
6 years agoNot applicable
Numbers rounded after load from Oracle database
Hi,
I'm importing data from an Oracle database.
Some of the fields have the format NUMBER (12, 2).
So when the fields contains a value like 1837804418,44 I get 1837804418 after the load.
It seems that Power BI has a limit of 10 digits for 1.2 columns . But I need the 12 digits.
I get a warning:
Can this be solved?
Thanks
R.W.
- Anonymous6 years ago
Hi,
I found a good solution for my problem.
I just changed the type from 1.2 Decimal Number to $ Fixed decimal number
Thanks
R.W.
2 Replies
- AnonymousNot applicable
Hi Anonymous ,
See if this helps
https://community.powerbi.com/t5/Desktop/Number-getting-rounded-off/m-p/245286
Regards,
Harsh Nathani
- AnonymousNot applicable
Hi,
I found a good solution for my problem.
I just changed the type from 1.2 Decimal Number to $ Fixed decimal number
Thanks
R.W.