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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Executions and time last run in power BI

Hi Team,

 

Is any possible way to get List the reports with the number of executions and time last run in power BI 

 

Regards,

Anand

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User

There is a view in the ReportServer database call ExecutionLog3 (see https://docs.microsoft.com/en-us/sql/reporting-services/report-server/report-server-executionlog-and... ) The documentation is for SQL Server Reporting Services, but it is still valid for Power BI report Server. By default I think this view only holds the last 60 days of report executions (you can change the amount of days to keep in the properties of the Report Server when you connect using SSMS). So by default you will be able to see when a report was last run in the last 60 days and count the rows to see how often is was run.

 

We actually extract data out of that view and load it into our data warehouse so that we get a much longer view of the history of report executions without bloating the size of our report server database.

View solution in original post

1 REPLY 1
d_gosbell
Super User
Super User

There is a view in the ReportServer database call ExecutionLog3 (see https://docs.microsoft.com/en-us/sql/reporting-services/report-server/report-server-executionlog-and... ) The documentation is for SQL Server Reporting Services, but it is still valid for Power BI report Server. By default I think this view only holds the last 60 days of report executions (you can change the amount of days to keep in the properties of the Report Server when you connect using SSMS). So by default you will be able to see when a report was last run in the last 60 days and count the rows to see how often is was run.

 

We actually extract data out of that view and load it into our data warehouse so that we get a much longer view of the history of report executions without bloating the size of our report server database.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors