Forum Discussion
Decimal Values Precision
Hmm, buffering didn't seem to work, I am trying with this:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjTSMzIEAiNjQyNDY0OlWB2gmLGeKRCYW5gbGgJpsJiBngEYgCRMDRFChgYGRmZGYKFYAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Decimal = _t]),
Buffer = Table.Buffer(Source),
#"Changed Type" = Table.TransformColumnTypes(Buffer,{{"Decimal", type number}})
in
#"Changed Type"
Now I see what you mean. Oddly enough, when that table is loaded to the datamodel, the missing decimals show up again. So it might just be a display issue in the query editor.
Ah, that's interesting. I wonder if someone from Microsoft can confirm that it is simply a display issue. I wonder if there is some calculation that could be performed to prove out whether or not it is maintaing the precision behind the scenes?
I don't think it is only display.
If you bring your data to the Report Pane, you don't see the remaining decimal even if I add precison from the formatting button.
I also tried to add "total" to my column and sum it. The result (sum) of the column show that the data was rounded at 6 of precision.
formatting Gregs example as Decimal - Decimal - with 15 digits
Returns all of them in the table view:
So if your SQL-data doesn't show the same behaviour, I'd still suggest to try the Table.Buffer first.
