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.
decimal is a dot not a ','
a ',' denotes seperation before the decimal. So this is a number with that seperation and a decimal: 896,352.25
I would suggest manipulating the data on import before PBI categorises it (e.g. in the SQL code) or change it in the source data.
Many Thanks
POC
So what is the differens here, it's no problem to get the value from the database in other tools Qlikview (BI) and Excel, but when I import to Power Bi it jus remove the "," sign and add it in the end instead, I can not understand why, and it is a huge database with all Costs in this format.
I just want Power BI to fetch the data as is in Table, no conversions.
Hi,
What I have understood from your query that you need to format the number (123,456.00) instead of looking as (123456.00). If this is the case then I would recommend to format the number using Column/Measure properties in Power BI, instead of formatting it in Power Query. Power Query is primarily meant for data transformation/editing. The data formatting (how it is going to look in the visuals) is done at Power BI desktop.
Regards,
Vivek
