Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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!
Solved! Go to Solution.
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.