Forum Discussion

Narukkp's avatar
Narukkp
Helper V
1 year ago
Solved

Track the deleted users in row level security section

Hi Team,

my report having row level security and in security section we added 10 users. But recently suddenly someone has removed 4 users’ emails in security section. Just we want to track that who has removed emails in security section. I checked in Admin portal but do not see any deleted user relevant activity.

Please let me know if any one having idea.



Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Narukkp ,

     

    You can track user activity in Power BI, and the Power BI Activity Log contains a complete copy of Power BI activities in a JSON array. You can export activity events to a Blob store or SQL database using a management application based on the Power BI REST API.

    More detailed information can be found in the documentation:Track user activities in Power BI - Power BI | Microsoft Learn

     

    In addition, this document provides examples to help you get started. These examples include scripts that use the Power BI Administration PowerShell module to retrieve data from the activity log. After determining the type of activity data you need, you can mix and match these techniques to generate a script that best suits your requirements.

    Access the Power BI activity log - Power BI | Microsoft Learn

     

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

3 Replies

  • Jonvoge's avatar
    Jonvoge
    Most Valuable Professional
    1 year ago

    Hi Narukkp

    I don't believe it is possible to do what you want to natively in Power BI.

     

    One option, is to assign members to an AD group instead, and add the AD group to the RLS rule.

    You can monitor, log and audit changes to the AD group through other tools, and ensure that the correct people are assigned.

    However, this will of course not solve your issue if people go and remove your AD group from the RLS rule.

    _____________________________________________________
    I hope my comment was helpful.
    If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
    Find me on LinkedIn, Sessionize, or my blog Downhill Data

    • Narukkp's avatar
      Narukkp
      Helper V
      1 year ago

      Jonvoge ,
      Yes, In one of the report some one deleted AD Group as well in RLS section . That's reason i want logs

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Narukkp ,

     

    You can track user activity in Power BI, and the Power BI Activity Log contains a complete copy of Power BI activities in a JSON array. You can export activity events to a Blob store or SQL database using a management application based on the Power BI REST API.

    More detailed information can be found in the documentation:Track user activities in Power BI - Power BI | Microsoft Learn

     

    In addition, this document provides examples to help you get started. These examples include scripts that use the Power BI Administration PowerShell module to retrieve data from the activity log. After determining the type of activity data you need, you can mix and match these techniques to generate a script that best suits your requirements.

    Access the Power BI activity log - Power BI | Microsoft Learn

     

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.