Forum Discussion
Last Refresh Date & Time is 1 hour out
Hi,
My report is scheduled to refresh every night at midnight as you can see in the Scheduled Refresh settings below:
However, when I check the report in Service the following morning the refresh seems to have run -1:00hrs earlier:
I think this is something to with British Summer Time and the clocks going forward one hour last weekend.
I've attached pbix file - can anyone help me fix this so the time is not 1 hour behind?
I created the Last Refresh Measure by following this instructions here:
https://blogs.perficient.com/2022/08/24/how-to-show-last-refresh-date-in-power-bi/
There are solutions in this link but I am not technical or proficient enough to adjust them for British Summertime & Wintertime changes:
https://gorilla.bi/power-query/last-refresh-datetime/
I'd be grateful for any help or a fix for this!
Thanks
It's a known bug. (UTC) Dublin isn't actually UTC. Use (UTC) Universal Time Coordinated
2 Replies
- lbendlin
Super User
It's a known bug. (UTC) Dublin isn't actually UTC. Use (UTC) Universal Time Coordinated
- ArchStanton
Power Participant
Thanks! I'll check tomorrow if it worked and will accept as a solution then (plus thumbs up)!