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

"Year" in the Power BI Service means "UTC Year".  Your year means "CET Year"  (assuming here).  That could make all the difference.

  • Loris_Chabardes's avatar
    Loris_Chabardes
    Frequent Visitor
    2 years ago

    Hello,

    So even whith my Power BI Service data stored in Paris, France; Power Bi service and desktop would analyse YEAR differently ? 

    Any idea on how to solve this ?

    Thanks

    • 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?