Forum Discussion

shera276's avatar
shera276
Kudo Kingpin
8 years ago
Solved

Report Server - Report Usage Statistics

Hi - PowerBI Service allows you to view report usage via the Admin Portal and in the service.  Is this possible in Report Server.  We are moving to report server and it would be nice to see report us...
Report Server + PBI Premium
usage
  • Anonymous's avatar
    Anonymous
    8 years ago

    shera276 The Power BI Report Server sits on a SQL instance (the same as normal SSRS) you have access to all the capabilities and information stored in the database. the view "dbo.ExecutionLog3" will provide you the metrics that you are looking for.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

shera276 The Power BI Report Server sits on a SQL instance (the same as normal SSRS) you have access to all the capabilities and information stored in the database. the view "dbo.ExecutionLog3" will provide you the metrics that you are looking for.

  • hernan_russy's avatar
    hernan_russy
    Regular Visitor
    8 years ago

    Hi shera276: I have the same question. Did you get the required audit info from this view?

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      hernan_russy The report server won't mimc the same metrics that you see in Power BI in that view. It will essentially provide you with who or what process executed the report. I have not tested this completely with Power BI Desktop executions, but my understanding is that this will be tracked in the same fashion.

    • shera276's avatar
      shera276
      Kudo Kingpin
      8 years ago

      Hi hernan_russy - Until this is available in Report Server, I created reports based on the following suggestion by another PowerBI users in the community:

       

      'The Power BI Report Server sits on a SQL instance (the same as normal SSRS) you have access to all the capabilities and information stored in the database. the view "dbo.ExecutionLog3" will provide you the metrics that you are looking for.'

       

      So I connected to the dbo.ExecutionLog3 view from our SQL database and was able to create some usage stats.

      • DaveW's avatar
        DaveW
        Advocate II
        8 years ago

        It would be good to have Usage Statistics function in Report Server

        I've created the same process, I pull the data from the log files into a table on a daily basis via a SP

        Then I can create reports in SSRS or Power BI by date by user, or even which reports have the longest rendering time

        SELECT 
Substring (el2.username,4,20) as Logs_User, 
el2.ReportPath as Logs_ReportPath,
CONVERT(varchar,el2.TimeStart,111) as Logs_Date, 
el2.TimeStart as Logs_TimeStart, 
el2.TimeEnd as Logs_TimeEnd, 
el2.[Status] as Logs_Status

FROM Portal.dbo.ExecutionLog2 el2  
--Portal is the name of my Report Server

where ReportPath not like '/02%' and Status = 'rsSuccess' and ReportPath != 'Unknown'
	and CONVERT(varchar,el2.TimeStart,111) = CONVERT(varchar,getdate()-1,111)
	and username not like 'NT SERVICE%'
	and Format  not like 'E%' 	and ByteCount != 0

        hope this helps

         

        cheers,

        Dave