Forum Discussion
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 our time sensitive environment, Is this possible? Possibly with a query to the report server db?
I have seen many posts that result in the current date/time being displayed, and I know how to do that, but that is not what I want.
Tnaks in advance.
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
9 Replies
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.
But the table only recalculates when it gets refreshed... So, "NOW()" is thus the "NOW" of when it was refreshed.
Create a column in some table in your dataset:
Refreshed = NOW()
NOW() is not the time of the Last Refresh. The time of the last dataset refresh might have been hours ago.Hello,
I want to show dataset refresh date and time in report page not page refreshd date and time.
Could you please let me know what need to do last dataset refresh page
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
