Forum Discussion
Different data between Power BI Desktop and Power BI Service after the upload
I am also experiencing this issue where once a refresh has taken place on Power BI service, the values of a calculated column change to the values on Power BI Desktop even though the data set has not changed. Has anyone managed to find any causes of this issue?
- Anonymous6 years agoNot applicable
Hi there,
i have the same problem.
After digging a little deeper into the subject matter, it seems to me to be an issue with time zones. My desktop has the timezone UTC+2, the dataset for example 07.07.2020 22:00. On the desktop the date is correctly interpreted as 08.08.2020. On the server as 07.07.2020, because the server runs on UTC.
Now I have to think about how to handle daylight saving time also, because I can't just add +2 hours.
Maybe I helped you, to have a clue, what might be going on. Sincerely