Forum Discussion
How to import values with decimals from database
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 this1,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.
Hello Maho
Did it solve your issue?
If yes, then please mark this question as answered. Answered questions help users in the future who may have the same issue or question quickly find a resolution via search.
Thanks!
Vivek
Hi vivek
No, it is not solved. I think I need to try another explanation.
Ín the database the value is 879,06 Euro, so around 879 Euro
After import to Power BI the cost is 87906 Euro, correct should be 879,06 Euro
Why does Power BI import remove the ","
Hi,
As noted earlier, you just need to format the number. if you are able to manipulate the data on its way into PBI then simply add '.00' on the end. That way your number will be a decimal as it comes in which you can then easilly format.
Many Thanks
POC
- I am not sure about "why the Power Query does that?", but if you want the thousand separator(,) in your visuals, then the method I suggested would definitely help.
Vivek
