Forum Discussion
Scheduled Refresh and BST
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
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