Forum Discussion

Helper V

10 years ago

Solved

last time refresh

Hi, Is it possible to add to the report/dashboard the date and time of the last refresh? Many thanks. Nir

nirrobi
10 years ago
Hi,

Maybe this will solution will help,

http://www.powerpivotpro.com/2010/11/add-a-last-refreshed-date-readout/

I will try tommorow and update :-)
idanco
10 years ago
Hi nir,

You can add a calculated column (Last Refresh Column) in the model with the formula =NOW()
And measure Last Refresh Date :=MAX(Table[Last Refresh Column])

Since calculated columns are calculated only on model refresh - it will make sure the calc is right

Frequent Visitor

8 years ago

Hi all,

Best way to actually do this is to pull in this website using the web conector https://www.timeanddate.com/worldclock/uk/london

***edit*** go here https://www.timeanddate.com/worldclock/uk

Use a card to display the cities time you would like :)

far easier than all this coding!

Anonymous
Not applicable
7 years ago
Thank you trysodin! Your idea worked perfectly for me. My previous solution was working but after the recent switch from DST to PST, it was off by an hour. This is a much simpler solution. Thank you!

let
    Source = Web.BrowserContents("https://www.timeanddate.com/worldclock/usa/san-francisco"),
    #"Extracted Table From Html" = Html.Table(Source, {{"LastRefresh", "[id*=""qlook""]"}}),
    #"Replaced Value" = Table.ReplaceValue(#"Extracted Table From Html","ST","ST; ",Replacer.ReplaceText,{"LastRefresh"})
in
    #"Replaced Value"