Dynamic RLS in power BI

[krishma]

Hi
can someone please help me with below scenario. it will be helpful.
 I have three tables (mentioned below), i want to achieve that if any user login , he or she should be able to see of their account and region only.
If user has access to multiple regions then it should be able to see multiple regions data,
if user has access to multiple accounts then he should be able to see multiple accounts data .
ex: Arun in below scenario , when he login should be able to see data of  GKA : abc , Abott and region will be Europe , NA, USA  LA.
below ill be data arun will be seeing:

GKA	User	Region	sales
Abott	Arun	Europe	700
Abott	Arun	NA	800
Abott	Arun	LA	900
Abott	Arun	USA	300
abc	Arun	Europe	400
abc	Arun	NA	100

Sales data as per accounts:

GKA	Region	sales
abc	NA	100
Pep	LA	200
Abott	USA	300
abc	Europe	400
Pep	NA	500
Abott	LA	1500
Abott	Europe	700
Abott	NA	233

 
User and Region details :

User	Region
Krishma Goyal	NA
David	LA
Arun	USA
Anusha	Europe
Senthil	NA
Reddy	LA
Arun	Europe
Arun	NA
Arun	LA

User details as per account:

GKA	User	email
abc	Anusha	Anusha@gmai.com
Abott	Arun	arun@gmai.com
abc	Arun	Arun@gmai.com
Pep	David	david@gmai.com
abc	Krishma Goyal	krishma@gmai.com
Abott	Reddy	Reddy@gmai.com
Pep	Senthil	Senthil@gmai.com

[Anonymous]

Hi @krishma ,

Based on the description, try to add the new email column in the region table. 

Then, try to manage roles and add the dax formula.

You can also view the following document to learn more information.

Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn

Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn

Bi-directional relationship guidance - Power BI | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[krishma]

Please help on this @Greg_Deckler  , @lbendlin , @SamWiseOwl  , @Ritaf1983 , @rajendraongole1 , 
@Thejeswar , @bhanu_gautam ,  @mickey64 

[Thejeswar]

@krishma ,

You can refer to the below link for a simple explanation on Dynamic RLS in Power BI

Dynamic Row Level Security with Power BI Made Simple - RADACAD

The Above page speaks about implementing for one column. 

In short, the Below should be the relations between the tables.

Apply the Userprincipalname() filter on both User and Region details and User details as per account tables.

Then the above two tables to be connected to the sales table such that they filter the sales table

Regards,

[krishma]

Hi
Thanks for helping but this loution will not help as i want for particular GKA which all regions persons has access only that the user should be able to see.
if i login as Reddy then he should be able to see:
Abott LA only not any other values

[Thejeswar]

@krishma ,

As per my understanding, the below will work.

Apply the Userprincipalname() filter on both User and Region details and User details as per account tables.

Then the above two tables to be connected to the sales table such that they filter the sales table

Just that you will have to be a little innovative in how the control gets passed from Security table to the other tables

Regards,

[krishma]

@Greg_Deckler @lbendlin @SamWiseOwl @amitchandak @rajendraongole1 please help em with above scenario