Execution metadata from Power BI Report Server

[omnia_saleh]

how i get who access my report on power bi report server , who edit on the report and delete and information on each report and who creat it .i mean i need all logs

[Anonymous]

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) | Micro...

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.

[omnia_saleh]

Thank you,what Is Type Of Metadata I Will Get?

[Anonymous · Accepted solution]

Hi @omnia_saleh ,

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.

[omnia_saleh]

why table [Event] and [history]in database ReportServer has no data in sql server managemet studio?

[ChrisMuthmann]

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.

[omnia_saleh]

why table [Event] and [history]in database ReportServer has no data in sql server managemet studio?

[ChrisMuthmann]

Same for me and that should be fine.

There is a documentation belonging to the events:

SSRS Subscriptions (What goes on "under the hood")  

[omnia_saleh]

Is it solved?

[josef78]

I think, Event table is not logging table, I have in this table only ReportRefresh events only during queuing (for very short time).

I History table, I have only snapshots for paginated reports.

[omnia_saleh]

i dont have data in table history , Subscriptions i want to see this data

[josef78]

In History table, there no data about subscriptions, but about Snapshots, it is something else.

History of executed subcriptions is in ExecutionLog3 view.

[omnia_saleh]

Thank you,what Is Type Of Metadata I Will Get And What Is The Steps To Get It?