Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Display Last Dataset Refresh On Report

I have users that want to see the Last DATASET refresh time on their reports.  So if the dataset refreshed at 1:00 and they view the report at 2:30, 1:00 should be displayed.  This is very useful in ...
dataset refresh
  • cbarrettEM's avatar
    cbarrettEM
    6 years ago

    For a SQL data refresh it will be stored in the logs

    ReportAction 19 is Data Refresh, so something like:

    select max(timeend) as LastRefresh from ExecutionLogStorage where reportaction = 19 and ReportID = YourReportID

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

But the table only recalculates when it gets refreshed... So, "NOW()" is thus the "NOW" of when it was refreshed.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

No... the dataset gets refreshed every few hours.  The REPORT may be refreshed NOW, but the data in the dataset the report reference is as of the last dataset refresh.  Pushing Refresh in the report does not refresh the underlying dataset,  These particular reports are not live queries,  They are too large and slow.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Yes, I agree, if you did have a column in a import data model that used NOW() in a column and whether a user presses "refresh" (which doesn't refresh the dataset) and you displayed that column in a card visual using MAX then they would see the date/time of the last time that the report actually did a real data refresh. Which was the original ask. Confused.