Forum Discussion

RWE's avatar
RWE
Regular Visitor
4 years ago
Solved

Difference in data when refreshed in Service

Hello Power BI Gods!    I am looking for advice! When I work on a specefic report in Desktop I calculate a number of about 15 Mil. I then uploade it to service, and the number is still about 15. Wh...
Need Help
  • RWE's avatar
    RWE
    4 years ago

    So at lbendlin  mentioned there was a problem with the seperators! in the currency converter the decimal seperator was a . instead of a , which resulted in the problems when uploaded to Service. Thank you for your help! 🙂

lbendlin's avatar
lbendlin
Super User
4 years ago

RWE Most likely a locale mismatch - comma and period as decimal separator vs thousands separator.  See if you can convert the source data to a more universal format.

RWE's avatar
RWE
Regular Visitor
4 years ago

Hi:) Yeah I though the same. But i think it is wierd that no other income seem to change. When looking at the excat same data in Desktop, the numbers are correct. And when uploading in SErvice, everything is fine. But if I update the report in service (the automatic refresh) the numbers suddenly change, and onl for one customer (who originally pays in antoher currency, but have been converted to the same currency as everything else).

 

Therefore I do not see how the seperator can be the problem 😞