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 then to Power BI, the decimal sign is in correct place.
Using ODBC from Oracle DB:
Export from Oracle to excel and then import to Power BI
Declaration in Database
The correct value should be 879,06, but I don't want to go throught an excelfile, because it is a huge amount of data.
Can someone help me with this issue?
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.
Helpful resources
Microsoft Fabric Learn Together
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
