Forum Discussion
Decimal Values Precision
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.
The problem is not loading the data in the model, it has more to do with caclulation in the Query Editor
See my example below, 1 column is data from the table straight into the data model, 2nd column is calculation (1/value from table) made in the query editor and 3rd column is calculation (1/value from table) made in the reporting pane.
Report PaneQuery Editor
