Forum Discussion
Tracking Dashboard Usage in Report Server
Thanks for the reminder.
The solution I applied was quite simple. In my case, I have 10 dashboards on the Power BI Server. I noticed that when any dashboard report is accessed, it returns 5 execution records if the dashboard is fully opened. So, I counted all the records and divided them by 5.
Hi, tmhalila
The ExecutionId in the ReportServer database table tracks each instance of the report execution. ExecutionLog2 means that even if you open the dashboard once, multiple entries may be logged due to different stages of report processing, such as data retrieval, rendering, and export.
Rather than relying solely on ExecutionId, you can track sessions by using ExecutionId in conjunction with other fields, such as TimeStart and TimeEnd, to group related executions.
You can also implement custom logging in your reports to capture user-specific details and actions. This helps distinguish between different users who share the same username.
If possible, record the IP address of the user accessing the report. This helps distinguish between different users who share the same username. Consider using a view, which may provide more detailed or user-friendly fields that can help with better tracking and analysis. You can check the following link:
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the suggestions. I tried using the ExecutionId with other fields, like TimeStart and TimeEnd, for group-related executions, but it didn't work because some stage executions are delayed for the same user.
The second and third options require admin privileges, so we can add IP tracking or implement custom logging. I will check with the team to see if these are possible. In the meantime, I will go with another alternative as I have observed execution stages repeat 5 times for each login account so I decided to count all and divide by 5.