Forum Discussion

Joachim2108's avatar
Joachim2108
Helper I
5 years ago
Solved

Decimal separator missing when importing data

Hi all,   I'm stuck with a very annoying issue - when I import data via an ODBC driver (connected to ERP software called Microsoft XAL), the decimals in the numerical collumns disappear!    E.g. ...
Need Help
  • Joachim2108's avatar
    Joachim2108
    4 years ago

    The solution in the end had to do with how I import my data. My organisation uses an Oracle Database (a very old 32 bit version), and when getting data, I would select "ODBC" which would then result in the issue of missing decimals. 

     

    The solution in the end was simply to select "Oracle database" when importing data. No issues followed after that.

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey Joachim2108 ,

 

after the first step in importing the data in Power Query change the type using locale: 

 

 Then change the format to to decimal number and region United States:

Afterwards you will have the numbers in the right format.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
  • Joachim2108's avatar
    Joachim2108
    Helper I
    5 years ago

    Hi Denis,

    Changing regional settings does not seem to work. When I do change the settings (Using Locale), Power BI gives me the message that i posted in my original post.