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​ 

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.

Hi ArchStanton​,

What you're seeing is usually a timezone difference rather than the refresh actually running at a different time.

In your screenshot, the dataset is configured in UTC, and the scheduled refresh is set to 12:30 AM UTC. If your refresh history or DAX measure is showing 00:30 while you're expecting 01:30, then one of the following is likely happening:

• The Power BI Service schedule is using UTC.
• Your DAX measure is converting timestamps to local time (or vice versa).
• The source system is storing timestamps in a different timezone.

The easiest way to verify is to check the Refresh History in the Service and compare the actual refresh start/end times against your measure. Refresh History is the source of truth for when the refresh really occurred.

I wouldn't change the schedule to 23:30 unless you've confirmed a timezone offset issue first, otherwise you may end up refreshing an hour earlier than intended.

Can you share the DAX measure you're using to display the refresh time? That will help determine whether the discrepancy is coming from the refresh schedule or the time conversion logic.