Row Level Security - avoiding user assigning to the role

[Ivaylodoynov]

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

[v-juanli-msft]

Hi @Ivaylodoynov 

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.

[amitchandak]

Refer, if this can help

https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies

https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns...

But you might have to continoue the current way.

[Greg_Deckler]

See if the blog article referenced here helps: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Hierarchical-Row-Level-Security/td-p...