Report Refresh Time always Wrong

Hello ArchStanton,
Thank you for sharing the screenshot.

The error occurs because in Power Query, each line must be added as a new step inside the let in block, with the previous step ending in a comma. If the new line is entered by itself in the formula bar, Power Query tries to evaluate AdjustedDateTime before it exists.

Please update your query like this Add the new step after AsDateTime:

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, {{AdjustedDateTime}}),

    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

Power Query steps work sequentially, so the new step must be part of the query and referenced later in AsTable.

Please try the above structure and let me know how it goes.

Best regards,
Ganesh Singamshetty