Dynamic RLS with multiple conditions

[sima_ue031]

Hello, 

i need a help, please.

I have table for roles. This table name is Roles_Divizija_TEST and data inside is :

In this table a have column Divizija, which have in second row multiple values which this user can see. 

After, i have a table DivizijaKupci and relationship between DivizijaKupci and Roles_Divizija_Test on DivizijaKupci.[Top Divizija]=Roles_Divizija_TEST.Divizija.

And last table is Kupci who contain a list of values of Customers. 
And have ralationship between DivizijaKupci.[Top Divizija] = Kupci.[Top Divizija].

here is my model : 

How i can see in roles for example Z_Broj = Z0560 for customers (Kupci) where [Top Divizija] in ("TD.DRVO","TD.INSTALACIJE").

Thanks in advice

[sima_ue031]

My model is on prem, and i have tabular model in background. 

Is possible that one user can be in two roles in onprem model?

[Anonymous]

Hi @sima_ue031 ,

Yes it is.

Best Regards,
Dino Tao

[sima_ue031]

How? Can you help me?

[Anonymous]

Hi @sima_ue031 ,

Can you say what database you are using for your tabular model? And the connection schema you are using in Power BI Desktop? Different databases and different connection schemas create RLS in different ways.

Best Regards,
Dino Tao

[Anonymous]

Hi @sima_ue031 ,

First of all, depending on what your RLS screenshot in Power BI Desktop shows, you may need more code to implement Dynamic RLS, which you can refer to this document:
Dynamic Row Level Security with Manager Level Access in Power BI - RADACAD
Also, once you have set up Dynamic RLS correctly, you will need to publish the report to Power BI Service and enter who you want to view it with in Security in the Semantic model.

Dynamic Row Level Security with Power BI Made Simple - RADACAD

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.