topic Re: I want to see who accessed the reports on my report server. in Report Server

I want to see who accessed the reports on my report server.

THEJMAN — Tue, 10 Sep 2024 10:14:55 GMT

Hello everyone, I'm having difficulty obtaining information about who accessed the Report Server reports and the data that these accesses occur.

I went to the directory where my powerBI is installed F:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles and there I found files mdmp, asmanagedroot.txt, reportingservice.txt, rshostingservice.txt, rsoffice.txt, rsportal. txt,rspowerbi.txt.

And I wanted help on how to get the access log.
Thank you for your attention.

Re: I want to see who accessed the reports on my report server.

ouakniny — Tue, 10 Sep 2024 12:31:27 GMT

Hi,

Have a look at the view dbo.ExecutionLog2 in the ReportServer database. If you are using pbix reports and you want more details on your user activity you can parse the dax queries in rspowerbi.log

Best Regards

Ilan

Re: I want to see who accessed the reports on my report server.

Anonymous — Thu, 12 Sep 2024 06:50:49 GMT

Your solution is great ouakniny

Hi, THEJMAN

As ouakniny said, you can connect to the database where your Report server is located via SSMS:

In ExecutionLog3, you can see information about who accessed the Report Server report and the data that occurred during those visits:

You can refer to the following link for documentation related to this log:

Use ExecutionLog and the ExecutionLog3 view in Reporting Services - SQL Server Reporting Services (SSRS) | Microsoft Learn

Ouakniny has answered your question. You can mark Ouakniny's reply as a solution so that others in the community can quickly find your post when they have a similar issue, saving them time.
Your cooperation will work with us to promote the development of the community. Thank you again for your cooperation!

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.