Tracking user activity

[Danri94]

Good Day,

I just got some PowerBI admin permissions for the report server. Do i have a chance to gather some information about the consumption of exisiting reports someone else has built?
If so, what do i have to set up for this?

What options do I have to obtain information on user activity?

Thanks in advance 🙂

[tharunkumarRTK · Accepted solution]

Not sure if there is any out of the box solution but you can built one for you using the DMVs
for your reference: https://data-mozart.com/check-power-bi-usage-metrics-on-report-server/
https://learn.microsoft.com/en-us/sql/reporting-services/report-server/report-server-executionlog-an...

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun

[Anonymous · Accepted solution]

Hi @Danri94 ,

You could get the information from the ExecutionLog3 views in PBIRS database.

For more details, you could read related document: SSRS ReportServer Database Overview and Queries (mssqltips.com)

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.

[tharunkumarRTK · Accepted solution]

Not sure if there is any out of the box solution but you can built one for you using the DMVs
for your reference: https://data-mozart.com/check-power-bi-usage-metrics-on-report-server/
https://learn.microsoft.com/en-us/sql/reporting-services/report-server/report-server-executionlog-an...

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun