add a second RLS in a composite model

[MariARParis]

Hello,

I have a star schema with an RLS already implemented and working correctly ( RLS connected to organization dimension )

I have a request to add another security on the product level but without making changes to the original model so I thought about using a composite model

I have added a new table containing the email and the product name (RLS Product ) and i've connected it to the Customer dimension ( to filter the appropriate product ). I was thinking about adding a new role using USEPRINCIPALNAME() but it doesn't work.

I've noticed that I don't have "apply security filter in both directions" for the new table and I'm not allowed to create a new role either.

Is it possible to add another RLS and if so, how to do that ?

Thanks for the help !

Mariem

 

[Anonymous]

Hi @MariARParis,

Have you solved your problem?

If the link provided by Ritaf1983 works on your side, please consider marking it as the answer.

If it is not your story, please provide more details.

Thanks for your cooperation.

Best Regards,

Qi

[Ritaf1983]

Hi @MariARParis 
Please relate to the linked guides:
https://www.youtube.com/watch?v=IX6FgC3cRwI

https://mitchellpearson.com/2018/10/08/using-composite-model-with-dynamic-security-in-power-bi/

and discussions :

https://community.fabric.microsoft.com/t5/Service/Row-Level-Security-on-Composite-Model/m-p/3094932

https://community.fabric.microsoft.com/t5/Service/RLS-not-working-on-Composite-Models/td-p/3092471

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.