Forum Discussion
Tracking user activity
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 🙂
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-ver15If 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
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.
2 Replies
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-ver15If 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
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.