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.

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?

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

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's avatar
    Loris_Chabardes
    Frequent Visitor
    2 years ago

    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.