Forum Discussion

Loris_Chabardes's avatar
Loris_Chabardes
Frequent Visitor
2 years ago
Solved

Data shown on PowerBi Service and Power Bi desktop are different

The title says it all. Some of my measures are showing different data on Power BI Desktop compared to Power BI Service after a refresh. After publishing my reports on a workspace, everything is okay...
Need Help
  • Loris_Chabardes's avatar
    Loris_Chabardes
    2 years ago

    I've discovered that my issue wasn't with the date format but rather with some numbers formatted differently between Power BI Service and Power BI Desktop.

     

    I cleaned my data source, and now it works consistently across both versions of Power BI.

     

    Thank you for your assistance.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Base all your datetime data on UTC and let the user's browser do the locale conversion.

Loris_Chabardes's avatar
Loris_Chabardes
Frequent Visitor
2 years ago

This was the original state of my files; I've re tried it and it dosen't work .. but, 

I've discovered that when I set my desktop's locale to US, the data displayed by my measures after a refresh matches that of the PowerBI service. It seems that the problem lies in the PowerBI service refresh process, which appears to run with US locale settings even though my data is stored in Paris and my PowerBI service language is set to French.

Is there any way to force the PowerBI service refresh to operate using French locale settings?