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. As soon as the report is updated via Power BI Service, some of my measures are showing wrong data. Refreshing my desktop file does not cause the problem.

From what I've seen on different forums, this could be due to "Regional parameters," but it seems that is not the case for me. My Power BI Service data is stored in Paris, France, so in the desktop app, I'm using the same parameters. Even in Power Query, I make sure that the date is formatted with French parameters.

 

I suppose the issue comes from this SQL line:

GROUP BY [EC_Reference], [SAGE_SRC], [CG_NUM], [EC_SENS], [EC_ANType], [JO_Num], YEAR([JM_DATE]);
 

I have to GROUP BY my data per YEAR([JM_DATE]) to show the correct data. And if I don't, the result of the measure is the same as in Power BI Service.

I'm quite confused about what could be causing this really weird issue, and I really need help about it.

Thanks, Loris

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.

7 Replies

  • 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

    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.