Forum Discussion
RLS Dimension
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 , 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
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