Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
1 year ago
Solved

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?

https://www.dropbox.com/scl/fi/5r6ldpa6c9wpyfgbqrb1s/LastRefreshTime.pbix?rlkey=x2qkqvlb2m3dwr5d0hccbnyuv&st=9n7mm5kt&dl=0

 

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

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

    • ArchStanton's avatar
      ArchStanton
      Icon for Power Participant rankPower Participant

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