Forum Discussion
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...
Hi Reportex,
You can try to utilize Power BI report server rest API:
https://docs.microsoft.com/en-us/power-bi/report-server/rest-api
https://app.swaggerhub.com/apis/microsoft-rs/PBIRS/2.0#/
Best Regards,
Qiuyun Yu
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!