Report Date/Time is changing on scheduled

[Anonymous]

Hello,

I currently have a Power BI Report that is displaying data from a MySQL Server. I have a daily scheduled refresh that occurs at 11:00 PM daily. I have noticed that after the scheduled refresh, the report date/time has been changing. However, when I select the option to Edit in Power BI Desktop, the report opens and display the correct Date/Time information. 

I have tried recreating the report to see if there was an error with my table setting, but date/time is still changing. I have attached two images. The one on the left reflects the correct date/time, and the one on the right reflects the date/time displayed after the scheduled refresh.

Any advice would be greatly appreciated. Thank you

[jguerrero]

I have a similar issue, but just in one dashboard.
The local machine is set to UTC-6 (Mexico) and the PBIRS is set to UTC-6 (CST US)
Information locally shows correctly (Let’s say Today at 9:24am) but in the server the field in the dashboard shows FIVE HOURS ahead (Today 14:24 PM!!!!)
Any ideas on:
- why is this only dashboard showing the wrong time? The other dashboards were created in the same local computer and published in the same server.
- why 5 hours? Both machines are in UTC-6, daylight turned on.

Any help will be appreciated.

[v-henryk-mstf]

Hi @Anonymous ,

Agree with the explanation given by @d_gosbell . If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

[d_gosbell · Accepted solution]

The most likely explanation for this is that the server running the refresh is using a different datetime offset to your local PC. If you are doing the refresh in the powerbi.com cloud service then the "servers" are all set to UTC time while your local PC looks to probably be set to UTC-6. You will probably need to add a step in your query to convert the datetimeoffset to a specific timezone. You can use the DateTimeZone.SwitchZone function https://docs.microsoft.com/en-us/powerquery-m/datetimezone-switchzone to do this. 

[Anonymous]

@d_gosbell thank you for this! I was able to Use the DateTimeZone.SwitchZone function, and after verifying my scheduled refresh, this worked. Much appreciated!