Forum Discussion
Decimal Values Precision
You have to change the type of the new calculated column to number in the query editor, otherwise it wouldn't work! (and format Decimal-Decimal-15 in data model).
Pls check this file, where everything works as it should: https://1drv.ms/u/s!Av_aAl3fXRbehbFUfBxB7xLJMuLZSw
But you do what is stated in my original post "I don’t have the same issue when I create a table in PowerBI directly and add the same values, my new column for row 1 has 1/12.211112312131 = 0.081892621608807947 as opposed to 0.081892 when I the table from the database."
I am not importing data into Power BI, I'm using direct query. I ommited the word "query" in my original post, sorry it would have made it clearer that I am in Direct Query mode.
Changing the format into the query editor did not change the precision.
By the way, thank you very much for you help solving this.
Indeed.
You might check if there is an issue filed on it already, otherwise open a new bug-report.