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

Create a column in some table in your dataset:

 

Refreshed = NOW()

 

Display the MAX of this in a Card visual. The calculated column will be updated when the data is refreshed. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    NOW() is not the time of the Last Refresh.  The time of the last dataset refresh might have been 2 hours ago.

    • 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.