Forum Discussion

omnia_saleh's avatar
omnia_saleh
Icon for Helper II rankHelper II
2 years ago
Solved

Execution metadata from Power BI Report Server

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
"Power BI Report Server"
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

ChrisMuthmann's avatar
ChrisMuthmann
Icon for Resolver II rankResolver II
2 years ago

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.