Forum Discussion
Power Bi Rounding Decimal Numbers up, even when not formatted to do so
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.
The data comes in as a Decimal Number, which makes this so confusing for me. This is a DirectQuery due to the size of the data model.
And the tables show the decimal places correctly when I go to Transform Data.
Weird, how would it be possible to see the data in table view/Power Query Editor when it is DirectQuery 🤔
You have to go into "Transform Data" to get a preview of the data. I also have access to the Snowflake data table the query pulls from and can confirm that the preview data matches the Snowflake data.