Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to 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!
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!
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
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.
User | Count |
---|---|
73 | |
72 | |
39 | |
25 | |
23 |
User | Count |
---|---|
96 | |
93 | |
50 | |
43 | |
42 |