Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
How can I export a list of all users and (Active Directory) groups that have various levels of access to all the different reports and folders in my organization's Power BI Report Server? I have access to the backend SQL server db as well for this. Thank you.
Solved! Go to Solution.
USE ReportServer
GO
select top 100 percent u.UserName, r.RoleName, r.Description, c.Path, c.Name
from dbo.PolicyUserRole pur
inner join dbo.Users u on pur.UserID = u.UserID
inner join dbo.Roles r on pur.RoleID = r.RoleID
inner join dbo.Catalog c on pur.PolicyID = c.PolicyID
order by u.UserName
USE ReportServer
GO
select top 100 percent u.UserName, r.RoleName, r.Description, c.Path, c.Name
from dbo.PolicyUserRole pur
inner join dbo.Users u on pur.UserID = u.UserID
inner join dbo.Roles r on pur.RoleID = r.RoleID
inner join dbo.Catalog c on pur.PolicyID = c.PolicyID
order by u.UserName
Hi @pborah ,
You can look into the Executionlogstorage, catalogue and the user table. You can go on my site and download a basic monitoring report for the report server. In that you can add more fields... yodabi.com after you created the report you can export all informations you need as csv 🙂
Best,
Kathrin
If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!
User | Count |
---|---|
11 | |
9 | |
4 | |
1 | |
1 |