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 usage metrics.

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.

7 Replies

  • 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

      • 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.