Scheduled refresh stamp not updating

[Anonymous]

I have an update stamp that updates ok when I press the refresh button manually, however when the scheduled refresh completes it doesn't update the last updated stamp, even though the scheduled refresh has completed ok?

Please can you help me. 

Many Thanks

[Whitewater100 · Accepted solution]

Hi:

Here is one way via Power Query. You go to GET DATA, BLANK QUERY > Click on ADVANCED EDITOR and paste this code over 

Source

Let

In

Paste on Blank Advanced Editor Page:

let

  Source = #table(type table[Date Last Refreshed=datetime], {{DateTime.LocalNow()}}),

    #"Added Custom" = Table.AddColumn(Source, "Date Last Refreshed UTC -4", each [Date Last Refreshed] - #duration(0, 4, 0, 0)),

    #"Changed Type1" = Table.TransformColumnTypes(#"Added Custom",{{"Date Last Refreshed UTC -4", type datetimezone}})

in

    #"Changed Type1"

Name query "Last Refresh"

Then you can add measures to reflect the refresh time. In my example I have two, one for regular UTC time and one for UTC time -4 hours.

Add Measure(s) to Table Fields on Right:

Refresh Date-Time EST= VALUES (Last_Refresh[Date Last Refreshed UTC -4])

Last Refreshed Date = Values('Last Refresh'[Date Last Refreshed])

PQ result: Last Refreshed Table

Refresh Date-Time EST= VALUES (Last_Refresh[Date Last Refreshed UTC -4])

Last Refreshed Date = Values('Last Refresh'[Date Last Refreshed])

Example of Meaure and card visual

Put this in card and change format to “Whole Number”

In DAX I have seen this measure

Last Refresh = UTC(NOW()

But via PQ is a better way, I have read.

I hope this helps!