Forum Discussion

aoliver's avatar
aoliver
Helper III
6 years ago
Solved

Different Result in refresh (Desktop vs Service)

Hello everyone I have an historical table, with basically a timestamp and a numeric value. The problem is that in powerBI Desktop, to show the correct number, I have to transform the decimal separa...
Need Help
  • aoliver's avatar
    aoliver
    6 years ago

    Hello, 
    I was able to resolve this issue with the help of powerbi Support (via ticket)
    The problem was the region I was using in a change type step in powerQuery


    Thanks

v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi aoliver ,

 

>>The problem is that in powerBI Desktop, to show the correct number, I have to transform the decimal separator (from . to ,) and then change it to decimal number (all in powerQuery)

 

Generally, the symbol "," stand for the thousand section marker in number value, for example "100,000,000".  If you transform the decimal separator (from . to ,), it will generate confusion for symbol "," and  "." . So recommend you not do the action "transform the decimal separator (from . to ,)", just set the decimal places .

Best Regards,

Amy 

 

Community Support Team _ Amy

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