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.

Ereon's avatar
Ereon
Regular Visitor
1 year ago

Already have the value set to not Sum and same issue.  Someone else posted they are encountering this as well with Direct Query from Snowflake.  First time I have had it though, as I have several dashboards pulling from Snowflake, but none have used this dataset till now.

v-veshwara-msft's avatar
v-veshwara-msft
Community Support
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.

  • v-veshwara-msft's avatar
    v-veshwara-msft
    Community Support
    1 year ago

    Hi Ereon ,
    Just wanted to check if the response provided was helpful. If yes, please consider marking it as "Accepted Solution" to assist others with similar queries. If further assistance is needed, please reach out.
    Thank you.

  • v-veshwara-msft's avatar
    v-veshwara-msft
    Community Support
    1 year ago

    Hi Ereon ,

    Just checking in to see if your query is resolved and if the above response was helpful.

    Feel free to reach out for further assistance.

    Thank you.