Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Report Date/Time is changing on scheduled

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 refr...
Schedule Refresh
Scheduled data refresh
Scheduled Refresh PowerBI
  • d_gosbell's avatar
    d_gosbell
    4 years ago

    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. 

jguerrero's avatar
jguerrero
Icon for Helper II rankHelper II
4 years ago

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.