RLS Dimension

[fishbone77]

Hi everybody

I'm struggling to implement my RLS requirements. I have the following datamodel, where the e-mail adresses of the employees are stored in the employee table. This table is connected to the dimension table via GlobalDimCode1. Each GlobalDimCode1 is assigned to a group which is stored in Level2Name. Now i want to set up RLS so that every employee can see all the data assigned to his group in Level2Name. I hope this makes sense. 

Can anybody nudge me in the right direction how to set up RLS for this case?

Any help is greatly appreciated. Thank you so much in advance!

[amitchandak · Accepted solution]

@fishbone77 , One of the ways it creates a new table by merging these two tables in the power query that has email and level 2 name. Then you can create RLS on this new table based on email and userprincipalname. This need table should join with employee

Merge Tables (Power Query) : https://www.youtube.com/watch?v=zNrmbagO0Oo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=16

Merge : https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[fishbone77]

hi @amitchandak 

thank you for your help. i was able to meet the rls demands by creating creating multiple RLS groups and adding AD-Usergroups to them. But i guess your way would have worked too. 

Thanks again