Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Malavi
Frequent 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
Memorable Member
Memorable Member

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
Memorable Member
Memorable Member

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!

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Kudoed Authors