Forum Discussion
Row Level Security - avoiding user assigning to the role
Hello,
I am having a situation with the Row Level Security.
What I am doing is this:
Formula
This is the "formula" I use to set the filter and I was hoping that after using "USERPRINCIPALNAME()" I would not be required to set additional groups(roles) in the web version of PowerBi.
This is the result when I am selection to view as the "Security Test" role. Absolutely fine no problems here.Security Test
However, when I try to switch to view from the app user point of view I get this:
Ordinary User without being added to Security Test role
After adding the user in the role. The result is what is actually expected. However, I am trying to avoid assigning each user one by one to the role.
adding user to the Test groupInformation to the Ordinary User after being added to the group
My question now - Is it possible to have the "Security Test" functionality without assigning users to this role in the web version of PowerBi.
Thank you in advance!
Ivo
3 Replies
- amitchandakSuper User
Refer, if this can help
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies
But you might have to continoue the current way.
- Greg_DecklerCommunity ChampionSee if the blog article referenced here helps: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Hierarchical-Row-Level-Security/td-p/889567
- v-juanli-msftCommunity Support
Hi Anonymous
Sorry for replying late.
It is needed to apply the step assigning role in power bi service in order to use RLS.
If this step is not applied, the RLS configuration won't work as expected.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.