Report server refresh report

[Malavi]

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!

[josef78 · Accepted solution]

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 

[Malavi]

Many thanks Joseph!