Forum Discussion

MarkEvansHW's avatar
MarkEvansHW
Helper II
6 years ago
Solved

Decimals Truncated with Direct Query in Workspace

Developing a set of reports using Direct Query (DQ) connecting to a set of Redshift tables. Going reasonably well, now encountered something I can't resolve.   In Power BI Desktop, when I do calcul...
Need Help
  • MarkEvansHW's avatar
    MarkEvansHW
    6 years ago

    I asked the admin for my data gateway if there were any updates pending. He indicated that there was a new version. He loaded that new version this morning and that fixed the problem. Thus, it appears this is a specific problem with Direct Query with specific Data Gateway versions.

     

    The new version of the gateway that he installed is 3000.31.3. 

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

You can try to use FIXED or ROUND function on Power BI Desktop before publishing to Power BI Service.

 

Best Regards,

Giotto Zhi

  • MarkEvansHW's avatar
    MarkEvansHW
    Helper II
    6 years ago

    Thanks for the suggestion. That does not work. FIXED appears to only work on an existing measure (not on the base table field) so I tried wrapping the AVERAGE function inside a FIXED function and the same issue appears: while the number is diplayed with decimal places, the number is truncated (2.8 comes across as 2.0).