topic Tracking user activity in Report Server

Tracking user activity

Danri94 — Mon, 26 Feb 2024 06:21:34 GMT

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 🙂

Re: Tracking user activity

tharunkumarRTK — Mon, 26 Feb 2024 06:32:46 GMT

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-and-the-executionlog3-view?view=sql-server-ver15

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

Re: Tracking user activity

Anonymous — Tue, 27 Feb 2024 08:52:00 GMT

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.