PowerBI Desktop Vs PowerBI Web - data display issue

[jaymanivannan]

Hi,

I have created a report by using direct query option from SAP HANA Database. The report is showing the decimal value (2 decimals) in Desktop version. I published the report. But, Web report is not showing the decimal value, it is rounding off the numbers. This decimal value is very important for us. Could any of you help me?

[jaymanivannan · Accepted solution]

I resolved the issue.  I have applied to_decimal function in the select SQL query for the decimal column. After this change, both Desktop and Web reports are showing the decimal value.