Forum Discussion

Ereon's avatar
Ereon
Regular Visitor
1 year ago
Solved

Power Bi Rounding Decimal Numbers up, even when not formatted to do so

I have a Total $ Sales Field that is brought in as a Decimal Number, Format set to Currency and two Decimal Places that is consistently rounding when display within a table.  Need some help figuring ...
Need Help
  • v-veshwara-msft's avatar
    v-veshwara-msft
    1 year ago

    Hi Ereon ,
    Thanks for the update and apologies for the delay.

    This issue seems to be related to the new Snowflake connector introduced in recent Power BI Desktop versions. When using DirectQuery, decimal values may appear rounded during aggregation even though the source data and preview show correct values.

     

    To work around this, go to File > Options and settings > Options > Preview features, and uncheck “Use new Snowflake connector implementation”. Restart Power BI and reload the dataset.

     

    Hope this helps. Please reach out for further assistance.
    If this post helps, then please consider to Accept as the solution to help the other members find it more quickly.


    Thank you.

d_vanstrien's avatar
d_vanstrien
Regular Visitor
1 year ago

Sorry, no solution to your issue but I am having the same problem. Data comes from SnowFlake (direct query) and the column comes through as a decimal number. The values are correct when they're not summed, but as soon as it is summed the rounding is applied.
Could this be a bug in the latest version of PBI deskop (Version: 2.144.679.0 64-bit (June 2025)) 
I have never experienced anything like this before.

 

 

Edit: All my problems are solved when I switch from Direct Query to Import. Unfortunately, using import is not always suitable.

  • Ereon's avatar
    Ereon
    Regular Visitor
    1 year ago

    Good to know I am not alone in this issue.  I cannot change over to Import because the data coming in is way to large.  3 years of sales, for over 2,500 stores, by day, by Item.