topic Re: Report server refresh report in Report Server

Report server refresh report

Anonymous — Wed, 27 Oct 2021 00:08:41 GMT

we have like 100s of reports in report server, I am going to check the shceduled refresh for each report and change them if they are not required to be refreshed frequently(for example we have many reports with every hour refresh)

I was wondering if there is any meta data regarding those refresh times for all files in one single report to show me the frequency of each report

Currently, I need to check all of them one by one which is very time consuming

not sure even that kind of report exist!

Re: Report server refresh report

josef78 — Thu, 28 Oct 2021 16:59:35 GMT

There is no any prebuilt report with scheduled refresh log/statistics. But you can create easily on Power BI report, there mutiple datasources which you can use:

-ExecutionLog3 view on SQL server where is ReportServer database - in this view is most important rows with RequestType=Refresh Cache and ItemActions with this order ASModelStream, DataRefresh and SaveToCatalog which can be success or not.

-Power BI Report Server API (https://servername/reports/api/v2.0/), where you can connect using Odata connector in Power BI report, there are important information in PowerBIReports table expanded by CacheRefreshPlans

-Table ReportSchedule and Subscriptions on SQL server in ReportServer database, where are same information as above

Re: Report server refresh report

Anonymous — Tue, 02 Nov 2021 21:02:14 GMT

Many thanks Joseph!