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

[THEJMAN]

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.

[ouakniny · Accepted solution]

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

[Anonymous · Accepted solution]

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 (S...

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.

[ouakniny · Accepted solution]

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