Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
bdpr_95
Helper I
Helper I

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

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.

 

bdpr_95_0-1751556710895.png

 

 

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!

1 ACCEPTED SOLUTION
bdpr_95
Helper I
Helper I

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!

View solution in original post

2 REPLIES 2
bdpr_95
Helper I
Helper I

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
Solution Sage
Solution Sage

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.