topic Re: Display Last Dataset Refresh On Report in Report Server

Display Last Dataset Refresh On Report

Anonymous — Thu, 23 Apr 2020 18:57:32 GMT

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.

Re: Display Last Dataset Refresh On Report

Greg_Deckler — Thu, 23 Apr 2020 21:37:54 GMT

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.

Re: Display Last Dataset Refresh On Report

Anonymous — Fri, 24 Apr 2020 16:51:46 GMT

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

Re: Display Last Dataset Refresh On Report

sharathkmv — Mon, 27 Apr 2020 07:46:12 GMT

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.

Re: Display Last Dataset Refresh On Report

cbarrettEM — Mon, 27 Apr 2020 13:56:13 GMT

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

Re: Display Last Dataset Refresh On Report

Anonymous — Thu, 30 Apr 2020 22:31:20 GMT

Thank you. We are working through some steps to get this automated, but I think this is the answer. Was disappointed that I can't just get high level logging and have to get everything,

Re: Display Last Dataset Refresh On Report

Greg_Deckler — Thu, 30 Apr 2020 22:47:56 GMT

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

Re: Display Last Dataset Refresh On Report

Anonymous — Thu, 30 Apr 2020 22:53:27 GMT

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.

Re: Display Last Dataset Refresh On Report

Greg_Deckler — Thu, 30 Apr 2020 23:06:53 GMT

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.

Re: Display Last Dataset Refresh On Report

ktkpatra — Tue, 16 May 2023 11:16:33 GMT

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