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  ,

 

Do the suggestions from engineers make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

 

Best regards

Amy

aoliver's avatar
aoliver
Helper III
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

  • dosc's avatar
    dosc
    Frequent Visitor
    3 years ago

    For people having the same issue, here is how to solve it:

    • Go to the Power Query Editor
    • Right Click on your Column and Select “Change Type > Using Locale…” (This has to be done before any type conversion happens)
    • Provide the data type and the matching locale setting to convert your data reliably

    I wrote a blog post about this issue with more context: Incorrect Power BI Report Data After Refresh