Forum Discussion
Report server refresh report
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
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
Many thanks Joseph!