topic Re: Usage breakdown of pages within a report in Report Server

Usage breakdown of pages within a report

shiv — Mon, 22 Oct 2018 06:14:31 GMT

Hi, I would like to get a breakdown of how many users are accessing a particular page on reports stored on PBI RS. I havent been able to find this data in the execution logs. Has anyone done anything similar or any suggestions? Thanks

Re: Usage breakdown of pages within a report

Jon-Heide — Mon, 22 Oct 2018 19:59:38 GMT

Query the report server catalog database. Look at dbo.ExecutionLog3, group by UserName and ItemPath. Should get you # of views. Just note that for PBIX desktop reports, it makes several requests for each view so don't over count.

Re: Usage breakdown of pages within a report

shiv — Sun, 28 Oct 2018 22:56:15 GMT

Thanks for the response! I'm actually looking to see how many times each page (tab) within the report has been viewed.

Re: Usage breakdown of pages within a report

Anonymous — Tue, 30 Oct 2018 08:23:13 GMT

I'm not aware that you can see the individualt traffic to each tab, just the report overall.

However, if this is not the case, I will be very interested to learn if it can be done!