Forum Discussion

andyor's avatar
andyor
Resolver I
5 years ago
Solved

Report Usage Metrics Report

Hi

 

Is there some setting that needs to be enabled somwhere to get this to work? The report is showing that 1 person in my organisation that viewed the report besides myself, but I know of at least 5-6 people who viewed the report across multiple days. These people have sent emails saying they liked the report and I hope they are all not lying only pretending they viewed it lol

5 Replies

  • FarhanAhmed's avatar
    FarhanAhmed
    Community Champion

    Is this for Power BI Service or PBI Report Server?

     

    If you are looking for Logs in PBIRS you can use below query 

     

     

     

    select ItemPath,UserName,CONVERT(Date,TimeStart) Date,Datepart(hour,TimeStart) [Hour]  ,Datepart(MINUTE,TimeStart) [Minutes],Datepart(SECOND,TimeStart) [Second] from ExecutionLog3 
    Group by UserName,CONVERT(Date,TimeStart),Datepart(hour,TimeStart),ItemPath,Datepart(MINUTE,TimeStart),Datepart(SECOND,TimeStart)
    Order by Date desc