Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all
We're cleaning up our licenses and i found a bunch of users, that have still a role assigned but do not work anymore in our company.
What did I do? I ran this query, this gave me all the users that are somehow on the Database.
select 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
A couple of them are not anymore working.
Is there a way to remove this users via another query or have i to remove them manually from the Power BI Frontend?
Many thanks
Brani
Solved! Go to Solution.
1) Remove user permission from reports (of folders) is not necesenary, if these peoples not working in company, then (I hope) their AD acccount are disabled or removed, and they cannot access.
2) Any modification in ReportServer database is not recommended, and not supported.
You can remove old users manually from GUI, or you can remove using REST API.
Remove them from where?
Hi @lbendlin
From the Database "ReportServer". The default DB.
Best Regards
Brani
1) Remove user permission from reports (of folders) is not necesenary, if these peoples not working in company, then (I hope) their AD acccount are disabled or removed, and they cannot access.
2) Any modification in ReportServer database is not recommended, and not supported.
You can remove old users manually from GUI, or you can remove using REST API.
Hi josef78
Thanks for your reply.
Users are removed from AD, but we keep track of leavers. But they are still counted in the "Roles", i.e. "contant manager" etc.
So the solution is GUI or REST API 👍
Many thanks / Beste Grüsse
Brani
That's something you will want to do in the database. Data write back features in Power BI are pretty much non-existent.
You can run an Update or Delete query the same way you ran your Select query. In fact, it is considered good practice to create the Select query first so you will know how many rows will be affected by the destructive operations.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
3 | |
3 | |
1 | |
1 | |
1 |
User | Count |
---|---|
8 | |
5 | |
4 | |
4 | |
2 |