Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Row level security

Hello,   I already know how to create row level security.   I want this feature now to automatically hide any values/data that is not inclueded in the IT group that I am apart of.    As I have ...
  • v-xicai's avatar
    5 years ago

    Hi Anonymous ,

     

    Currently, the action you are doing is to test the results of the roles within Power BI Desktop. Since you are the creator of pbix with RLS , you can choose which roles to be test. If you would like the specific users to view the specific data report, you may publish the pbix to Power BI Service, add a member to the role by typing in the email address, or name, of the user, security group or distribution list you want to add under the Security page.  Then this RLS will be applied for different users with viewer permission instead of Admin, Contributor or Member.

     

    For reference:

     

    Row-level security (RLS) with Power BI

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

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

  • Anonymous's avatar
    Anonymous
    5 years ago

    hi Anonymous, as mentioned by v-xicai  - since you are the owner of the report RLS will not apply when you log into the report in PBI service - RLS only applies to users who have viewer access on report. Users with member, contributor or admin access will not see any effect of RLS. 

     

    Easier approach may be to create a seperate report for IT view with non-IT related data filtered at report level. Hope this helps!  

     

    Please mark the post as a solution if my comment helped with solving your issue. Thanks!