Forum Discussion

NielsvR's avatar
NielsvR
Regular Visitor
5 years ago

Different dates in desktop and service

Hi all,   With one of my reports I have the issue that dates are offset by one day from Power BI desktop to the Service. For example, June 1st in the desktop version becomes May 31 in the service. ...
Need Help
carlavd's avatar
carlavd
Frequent Visitor
2 years ago

Thank you for your answer. I was hoping this would be the solution. So I did "change type" > "Use Locale". But the behaviour was the samen. In Power Bi Desktop the date showed correct 19 the of May. When I published to the service and visualized the report I also got 9 the of May but after 5 seconds it changed to 18th of May.

 

To try and pinpoint the issue: I made a field showing the current date and time. On publishing the same behaviour: first showing the correct time and than switching to my time -2 hours. And my time zone is UTC-2.  But I can't make Power Bi service aware of the fact that I'm in UTC-2. A workaround is manipulating the date but I prefer not to do so because I will see different data in power bi desktop and on the service.