topic Re: RLS Dimension in DAX Commands and Tips

RLS Dimension

fishbone77 — Thu, 16 Mar 2023 14:12:00 GMT

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!

Re: RLS Dimension

amitchandak — Fri, 17 Mar 2023 01:56:50 GMT

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

Re: RLS Dimension

fishbone77 — Wed, 22 Mar 2023 10:00:00 GMT

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