Forum Discussion

Shanemougham's avatar
Shanemougham
New Member
1 year ago
Solved

Power bi - Direct Query Mode - Round off the decimal value while displaying table or chart

Team, I am using power bi desktop version 2.142.928.0 64-bit (April 2025).  I am connecting dataset(view) from Snowflake to powerbi via direct query mode, dataset contains Numeric(18,4). I could see...
Need Help
  • Shanemougham's avatar
    Shanemougham
    1 year ago

    Anonymous, Microsoft team advised it might be due to new snowflake conector implematation.  As work aorund - uncheck from preview feature. 


    From the Power BI Desktop, navigate to Options and settings (under the File tab) > Options > Preview features, and then “unselect” the checkbox to enable the Use new Snowflake connector implementation option.

     

    Thanks for support

Shanemougham's avatar
Shanemougham
New Member
1 year ago

Hi Anonymous, Thanks for your response. Tried this option, but sill not working.


Below is Dataset when viewed in  transform data panel:

I tried all possible formatting in table or matrix. However it doesnt fix this issue. 
Also I have created reports using this dataset with direct query mode, it works fine. But when i try for the new report with latest power bi update its not working.

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Shanemougham ,

 

Thank you for the update.

Sergii24 Thank you for your response.

 

Please try to create new calculated column using any of the below DAX query.

con = CONVERT(decimal[Value],DOUBLE)
 
or
 
dec = FORMAT(decimal[Value],"0.000")
 
then use these columns in visual. 

If the issue still persists, I’d recommend raising a support ticket with Microsoft as Sergii24 suggested.The support team can look into the backend and provide more in-depth assistance tailored to your environment.

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy

  • Shanemougham's avatar
    Shanemougham
    New Member
    1 year ago

    Thanks Anonymous, I tried with new column it didnt work as well. I will raise issue with microsoft.