Forum Discussion

Brani's avatar
Brani
Frequent Visitor
2 years ago
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...
powerbi
Report Server
SQL
  • josef78's avatar
    josef78
    2 years ago

    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.

lbendlin's avatar
lbendlin
Super User
2 years ago

Remove them from where?

  • Brani's avatar
    Brani
    Frequent Visitor
    2 years ago

    Hi  lbendlin 

    From the Database "ReportServer". The default DB.

    Best Regards
    Brani

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      That's something you will want to do in the database. Data write back features in Power BI are pretty much non-existent.

      • Brani's avatar
        Brani
        Frequent Visitor
        2 years ago

        Hi  lbendlin 

        That was my question 🙂 do you know how to do it?

    • josef78's avatar
      josef78
      Memorable Member
      2 years ago

      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.

      • Brani's avatar
        Brani
        Frequent Visitor
        2 years ago

        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