Numbers rounded after load from Oracle database

[Anonymous]

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.

[harshnathani]

Hi @Anonymous ,

See if this helps

https://community.powerbi.com/t5/Desktop/Unexpected-long-numbers-round-in-Table-visual/td-p/1082517#M56541

https://community.powerbi.com/t5/Desktop/Number-From-Excel-Automatically-getting-rounded-in-PowerBI/m-p/905922

https://community.powerbi.com/t5/Desktop/Number-getting-rounded-off/m-p/245286

https://community.powerbi.com/t5/Desktop/Number-values-are-getting-round-off-automatically/m-p/468478

Regards,

Harsh Nathani

[Anonymous · Accepted solution]

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.