cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Malavi
Regular Visitor

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!

1 ACCEPTED SOLUTION
josef78
Super User
Super User

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 

View solution in original post

2 REPLIES 2
josef78
Super User
Super User

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 

View solution in original post

Malavi
Regular Visitor

Many thanks Joseph!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.