Forum Discussion
Solved
Remove leavers/users in SQL possible?
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 th...
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.
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.