Forum Discussion
Decimal Values Precision
How can a change the precision of a decimal value Let says I have the following table CREATE TABLE dbo.Test (Column1 NUMERIC(32,12)) INSERT INTO dbo.Test VALUES(12.211112312131),(13.5555787...
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.