Forum Discussion

SIMMI's avatar
SIMMI
Frequent Visitor
2 years ago
Solved

Issue with decimals when exported from Power Bi Web service

Hi,

I'm facing a very strange issue on my report. I managed to create the same issue on a test version with one value to illustrate. I have a decimal value 1.123456789 as the input. But I have reduced it to 3 decimals.

The data exported from Power BI desktop works perfectly and I get 1.123.

 

But when I export from Power Bi Service, it retains the actual number of decimals. How can I fix this?

 

One option is to use the ROUND() on DAX. But I have almost 100 columns, so is there any better way of achieving this?

Regards,

Simmi

Need Help
Show and Tell
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    Hi, SIMMI 

     

    This is By Design. This is considered client side formatted and is not included in Export.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-zhangti's avatar
    v-zhangti
    Community Support
    2 years ago

    Hi, SIMMI 

     

    This is By Design. This is considered client side formatted and is not included in Export.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.