Forum Discussion
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 to manually have to select IT in the security.
So essentially I do not want to keep doing this, as I want an automatic version where becuase I am part of the IT group, it automically just shows that data.
Any help will be appreciated!
Thanks,
ChinIT
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.
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!
4 Replies
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
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.
