Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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