Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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.

  • Anonymous's avatar
    Anonymous
    6 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