Data shown on PowerBi Service and Power Bi desktop are different

[Loris_Chabardes]

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

[Loris_Chabardes · Accepted solution]

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]

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

[Loris_Chabardes]

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]

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

[Loris_Chabardes]

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?

[lbendlin]

When you change column types in Power Query you can specify a culture.  In your case you can enforce the 
"proper"  interpretation by specifying "fr-FR"  there.

[Loris_Chabardes]

Already tried as mentioned in my first messages, 'Even in Power Query, I make sure that the date is formatted with French parameters.' It seems to change nothing because my locals file (And global) settings are already set to French.