Forum Discussion

Maho's avatar
Maho
Frequent Visitor
6 years ago
Solved

How to import values with decimals from database

I have problem to import values (number) with two decimals from oracle database, the decimals sign (,) is not included in the value when I import via ODBC, but if I export to an excel file first and ...
Need Help
  • Maho's avatar
    Maho
    5 years ago

    I finally solved this issue with, I fetch the data from an Oracle database with American setup, so I had to do following steps

    1. Change NLS Language in Regedit to American (see picture), then restart computer

     

     

     

     

     

     

     

     

     

     

    2. Change the Regional settings on the Computer, then restart again.

     

     

     

     

     

     

     

     

    3. Check PowerBI settings to make sure it fetch from windows settings

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    4. Finally restart PowerBI.


    Now I got the result for numeric values for example like this

    1,253.69 ( , = thousand separator and . = decimal separator) this works for me now I get all decimals and the calculation is correct.

     

    I hope this will help anyone who has the same problem, I strugled with this for a while.

Anonymous's avatar
Anonymous
Not applicable
6 years ago
 

Hi Maho 

 

The Column header shows that you have imported a 'Decimal Number' 

 

I think the issue may be more related to the formatting of data in PBI.  Perhaps you could try with the 'Data' view and 'Column Tools'

 

 

Hope this helps Sduffy

 
  • Maho's avatar
    Maho
    Frequent Visitor
    6 years ago

    Sorry, I can not get this to work, it only add the decimal after the value ( and then it will be 87906,00 instead of 879,06.

    value shoud be 879,06 and when I add instead with decimal after  87906,00 and that is faulty.

    Is it possible to somehow use a script

    = Table.TransformColumnTypes(...