Last Refresh Date & Time is 1 hour out

[ArchStanton]

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?

https://www.dropbox.com/scl/fi/5r6ldpa6c9wpyfgbqrb1s/LastRefreshTime.pbix?rlkey=x2qkqvlb2m3dwr5d0hcc...

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

[lbendlin · Accepted solution]

It's a known bug. (UTC) Dublin isn't actually UTC. Use (UTC) Universal Time Coordinated

[ArchStanton]

Thanks! I'll check tomorrow if it worked and will accept as a solution then (plus thumbs up)!