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
    5 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

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