Forum Discussion

Reportex's avatar
Reportex
Advocate II
8 years ago
Solved

Report on Report Server Folder Structure

Hi   Is it possible for Power BI to report on itself?   I want to set up a PBI file that reports on the folder structures I have in my Report Server environments so that I can do comparisons betw...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Another option would be to connect directly to the ReportServer database.

 

We have a report on our server which queries the ReportServer database execution log, so we can see how many people are running the reports, seems to work very well.

 

We've connected the model in our report to Active Directory in order to get full user details from the logon name stored in the execution log. Our AD is structured by division/department, so we can see which departments are making use of the server. It's really useful!

djanszentql's avatar
djanszentql
Helper I
6 years ago

Hey I know this post is old, but how did you connect to AD?  Is there a general table that you can query and connect to?  I see UserName column in the ExecutionLogStorage table, but not sure where companies generally store AD information.  I don't believe we use Azure, but I could be wrong... pretty sure it is on Prem.