Forum Discussion
Help! regarding RSL Role
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
2 Replies
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/MyAccountingTricksthanks 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
.. ..
.. ..
