cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
biswad Frequent Visitor
Frequent Visitor

Row Level security (RLS) not dynamic

Hi Friends,

 

I have set up RLS based on the user email_id as  [Email] = USERPRINCIPALNAME()  . In order to get it work i have created a dataset containing the useremail list along with their sales area and than created another table call Sales area where i have created many to one relationship on my emailID dataset. After i publish my dashboard i also need to add all the email ID which i have alread listed on my dataset under dataset-->security option.

 

What i know is thats a dynamic approach but if it is Dynamic ,why you have to add emailID in security section,once he login power bi should know the user from his login ID and show him the region he belongs ? i mean if i have 50 users do u want me add those 50 users,then it is not dynamic right,can you please help to configure dynamic security in power bi.

 

Thanks, any help much appriciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Row Level security (RLS) not dynamic

Well, RLS works by putting users in roles. But, have you seen this article:

 

https://community.powerbi.com/t5/Community-Blog/Different-approach-to-Dynamic-Row-Level-Security/ba-...

 

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


2 REPLIES 2
Super User
Super User

Re: Row Level security (RLS) not dynamic

Well, RLS works by putting users in roles. But, have you seen this article:

 

https://community.powerbi.com/t5/Community-Blog/Different-approach-to-Dynamic-Row-Level-Security/ba-...

 

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


biswad Frequent Visitor
Frequent Visitor

Re: Row Level security (RLS) not dynamic

Thanks Greg, Much appriciated.

 

Kind Regards,

Biswa