Forum Discussion
Report Date/Time is changing on scheduled
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.
Super UserThe 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.
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!