Execution metadata from Power BI Report Server

Have a look at the PBIRS metadata in the ReportServerPBI database. Starting with this sql:

Select c.Path, c.Name, u.UserName as CreatedBy
from ReportServerPBI.dbo.Catalog c
Left Join ReportServerPBI.dbo.Users u
on c.CreatedByID = u.UserID;

There are some views as well in this database and [ReportServerPBI].[dbo].[ExecutionLog3] should give you a lot of information regarding the access.

Hi omnia_saleh ,

As ChrisMuthmann mentioned, there are some system tables and views when you have installed the PBIRS, all the operations you do in PBIRS are logged into the corresponding table, which you can query.

There are some documents that you could refer :

 SSRS ReportServer Database Overview and Queries (mssqltips.com),

Report Server ExecutionLog and the ExecutionLog3 View - SQL Server Reporting Services (SSRS) | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.