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
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!