Forum Discussion

cem's avatar
cem
New Member
5 years ago

Extra digits appear after exporting data

Hi,

When I export a data set and extra digits are popping up for some of the numbers (e.g. 302.14300000000003, 19.100000000000001, 64.099999999999994, 162.30000000000001, 38.400000000000006, etc.). Numbers in bold are what I have in excel. I'd apprecaite if anyone has any suggestions.

Cheers,

Cem

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    cem , Actually excel internally store higher place, but display only required one. That can be one reason.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi cem ,

    Which visual you are using to export data? Could you share the data type of related value field in Power BI? If it set as Decimal number, how many decimal places are set?

    Best Regards
    Rena
    Community Support Team _ Rena Ruan
    If this post helps, then please consider Accept it as the solution to help the other members find it more.