Forum Discussion

andyor's avatar
andyor
Icon for Resolver I rankResolver 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
    Icon for Community Champion rankCommunity 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