Forum Discussion
Row level security
- 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.
- Anonymous5 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!
Anonymous , not very clear. See if this what you are looking for
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2020-feature-summary/#_Perspectives
Hello,
What I am trying to achieve is that if I am part of the IT group, then all the data that is not required and not part of IT will be hidden.
Currently as you can see I have achieved that, but I have to do it manually.
I want it to be done automically