Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 ?
@pepita0000 so it means your source has more than 4 decimal point data, correct?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
At the source, the column is defined as numeric(38, 12)
@pepita0000 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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
If I use decimal, it will be rounded up because the highest precision is 15 digits per literature.
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |