Round up 15 digit number + 2 decimals using Fixed Decimal Number data type SQL(17, 2)

[Anonymous]

Hello,

I have two numbers that are being rounded when using a table visualization. When I check the power query, I have long numbers like this 128903545856362.27 or like this -118379514151571.95, which are the same as in the database. Data type is set to Fixed Decimal number.  When I look for the number in the  table visualization, then I find the first number rounded to 128903545856362.30 and the second one to  -118379514151572.00. If I copy the number from the table and paste it into a txt file,  I see the same number as the one in the power query or database 

I understand that a Fixed decimal number data type allows for 19 digits (SQL Decimal(19,4)) per literature (https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-types). My question is why is rounding up  these numbers when there are only 15 digits of significance and 2 digits after the decimal separator. Even if I can't fix this issue, is there a way to export the original number ?

[parry2k]

@Anonymous so it means your source has more than 4 decimal point data, correct? 

[Anonymous]

At the source, the column is defined as numeric(38, 12)

[parry2k]

@Anonymous weird, what about if you change data type to decimal number  instead of fixed decimal number and also in the table visual, try to set the format to 4 decimal digits and see if that makes a difference.

[Anonymous]

If I use decimal, it will be rounded up because the highest precision is 15 digits per literature.