Forum Discussion
Report server refresh report
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!
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
2 Replies
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