Help! regarding RSL Role

[Ahmed_Khalil]

Hello All,

Thanks in advance for Helping me regarding below:

i have two table in PBI Report

1. Data Table

Data table contains  a lot of columns but below Two Major Columns here is the distinct Values for each:

Country [UK, ES, PT, GR, EG, LP, IT, IE, SP]

Category [Laptop, Chairs, TV, Air Condition, Printer, PC, Doors]

2. User table 

User Tables Contains 3 Columns Only

E-mail = User E-mail

Country = some time user have access for All-which means have access to all country or two or three countries like IE,SP- which have access or these two countries or one country like UK which have access to only one country

Category = some time user have access for All-which means have access to all Categories or two or three Categories like TV,Doors- which have access or these two Categories or one Category like TV which have access to only one Catgeory

so how do i manage this by RLS

[Ahmed_Khalil]

@PijushRoy 

thanks for your supporting but unfortunately it doesnt work, beacuse here is the use case 

in case i have 

user      Country     Category

X            AL,ES           TV, Doors

incase i made concatenate i cant match it with datatable due to the data in this this table like this

Country       Category            Column1     Column2 .......

AL                  TV

AL                   Doors

ES                    TV

ES                    Doors

..                         ..

..                        ..

[PijushRoy]

Hi @Ahmed_Khalil 

Please try this approach
You 2nd table has email id where you can implement dynamic row level security based on which user login.
To do this, in
in both tables create a calculated column and CONCATENATE County & Category column
Create Relationship with new calculated column
Create RLS in 2nd table 
Find dynamic RLS steps https://www.youtube.com/watch?v=jphj40tBPD8

If your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.

Thanks
Pijush
www.MyAccountingTricks.com 
https://www.youtube.com/MyAccountingTricks