Refresh Time Disparity

Hi ArchStanton​ 

Thanks for reaching out to Fabric Community Forum.

The discrepancy is most likely caused by the difference between the timezone used by the scheduled refresh and the timezone used in your Power Query timestamp. Power BI Service executes scheduled refreshes in UTC, so your 00:30 UTC slot corresponds to 01:30 UK local time during daylight saving.

In your query, although AdjustedDateTime adds one hour, that value isn’t actually used in the output table, the table is built from AsDateTime. That’s why Fig. 3 doesn’t reflect the adjustment.

If the business requirement is 01:30 UK time, configure the refresh timezone to UK and schedule it for 01:30. Power BI will automatically align UTC vs BST/GMT.

Finally, use the dataset’s Refresh history in the Service to confirm the actual refresh start time. This is more reliable than relying on the custom “Last Refresh Date” field in the report.

Useful Links:  https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

https://learn.microsoft.com/en-us/powerquery-m/m-local-fixed-utc-variants

Hope this helps!!

Thank You.

Here is the code for it:

let     Source           = DateTimeZone.UtcNow(),     UKTime           = DateTimeZone.SwitchZone( Source, 0, 0 ),     UKAdjusted       = DateTimeZone.ToLocal( Source ),     AsDateTime       = DateTimeZone.RemoveZone( UKAdjusted ),     AdjustedDateTime = AsDateTime + #duration(0, 1, 0, 0),     AsTable          = #table( 1, {{ AsDateTime }} ),     RenamedCols      = Table.RenameColumns( AsTable, {{"Column1", "DateTime"}} ),     ChangedType      = Table.TransformColumnTypes( RenamedCols, {{"DateTime", type datetime}} ),     WithDate         = Table.AddColumn( ChangedType, "Date", each DateTime.Date( [DateTime] ), type date ),     WithTime         = Table.AddColumn( WithDate, "Time", each DateTime.Time( [DateTime] ), type time ) in     WithTime

Pasting it again because the Insert Code feature is broken:



let

Source = DateTimeZone.UtcNow(),

UKTime = DateTimeZone.SwitchZone( Source, 0, 0 ),

UKAdjusted = DateTimeZone.ToLocal( Source ),

AsDateTime = DateTimeZone.RemoveZone( UKAdjusted ),

AdjustedDateTime = AsDateTime + #duration(0, 1, 0, 0),

AsTable = #table( 1, {{ AsDateTime }} ),

RenamedCols = Table.RenameColumns( AsTable, {{"Column1", "DateTime"}} ),

ChangedType = Table.TransformColumnTypes( RenamedCols, {{"DateTime", type datetime}} ),

WithDate = Table.AddColumn( ChangedType, "Date", each DateTime.Date( [DateTime] ), type date ),

WithTime = Table.AddColumn( WithDate, "Time", each DateTime.Time( [DateTime] ), type time )

in

WithTime

Hi ArchStanton​ 

If you want the refresh to run one hour earlier (00:30 UTC), keep the timezone set to UTC and simply change the scheduled time to 00:30.

Do not select UTC-01:00, as this would shift the equivalent UTC execution time later, rather than earlier.

If your goal is to keep the refresh at 01:30 UK local time, select Dublin, Edinburgh, Lisbon, London (UTC+00:00). This timezone automatically accounts for daylight saving time, so the refresh will run at 01:30 GMT during winter and 01:30 BST during summer.

Hi ArchStanton​ 

Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.