Forum Discussion
Scheduled Refresh and BST
Hi All,
Here in the UK we have recently moved over to British Summer Time (BST) which is GMT +1. I have no issues as the report i've built refreshes every hour and is used in the UK and Boston. However in my report I have a last refreshed date/time (which is an hour behind)
However if you look at the report/dataset both are saying the following;
After spending an hour researching what the issue is and not finding anything.
The correct time of the refresh was in fact
and I'm wondering if there's a solution to get the 'last refreshed' date/time correct (ie 2022-03-29 17:14)
Thanks
Hi SRobbo1990
The clock inside Power BI service always runs in UTC and various places then modify this to local time when it is displayed. However this means that if you get the time in a Report from a measure like TIME=NOW() you get the time in UTC. This wasn't a problem last week, when the UK was on GMT which is effectively the same as UTC, but now we are on BST you'll need to do something like BST = NOW()+(1/24). This, I know, is a dirty hack, so here are some links to how you can do this properly if you want.
Dynamic time zone conversion using Power BI – The White Pages (unlimitedviz.com)
Hope this helps.
Stuart
2 Replies
Hi SRobbo1990
The clock inside Power BI service always runs in UTC and various places then modify this to local time when it is displayed. However this means that if you get the time in a Report from a measure like TIME=NOW() you get the time in UTC. This wasn't a problem last week, when the UK was on GMT which is effectively the same as UTC, but now we are on BST you'll need to do something like BST = NOW()+(1/24). This, I know, is a dirty hack, so here are some links to how you can do this properly if you want.
Dynamic time zone conversion using Power BI – The White Pages (unlimitedviz.com)
Hope this helps.
Stuart
I implemented the dirty hack and it appears to be working
Thanks
