Direct Query with Snowflake: Decimal Values Always Rounded – How to Show Two Decimal Places?

[bdpr_95]

Hi everyone,

I'm currently using Direct Query for a report, but I noticed that the values are always rounded to whole numbers, even when I want them to display with two decimal places.

To investigate, I ran a test comparing Import mode and DirectQuery, and the issue only occurs with DirectQuery. Below is a simple test I did to confirm this behavior.

Important Note: My data source is Snowflake.

Has anyone experienced this?
Do you know how I can ensure that values retrieved via Direct Query are shown with two decimal places instead of being rounded?

Thanks in advance for your help!

[bdpr_95 · Accepted solution]

Hi @ajaybabuinturi, 

Thank you for your input, but that solution didn’t resolve the issue. I’ve since found the answer in this link.

Another possible fix is to go to the Advanced Editor (in the query where the issue occurs) and simply remove the part that says: Implementation="2.0"

Thanks again for your help!

[ajaybabuinturi]

Hi @bdpr_95,
When we are using Direct Query to Snowflake, sometimes infers column data types incorrectly, especially for FLOAT/NUMBER columns with decimals. Specifically in below cases

1. Power BI interprets Snowflake's NUMBER(10,2) or FLOAT as whole numbers (INT64) in DirectQuery.
2. Import mode fetches the full precision correctly.
3. DirectQuery pushes queries to Snowflake and relies on inferred metadata, which may result in decimal truncation or rounding.

Considering these points you can explicitly cast the decimal number in Snowflake query as below.
CAST(column_name AS NUMBER(18,2)) AS column_name or CAST(column_name AS FLOAT) AS column_name

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.