RLS with same level view for regions

[reynaldo_malave]

Hi guys, 

I have this problem for a couple of days now but I can´t figure it out. Here is the thing. I have many counties with stores in it each store has a supervisor. I have rls setup where each supervisors can see his/her stores. I have been asked to level up security parameters by county where a supervisor can see his/her stores and also other stores in the same county. I show you a picture of the schema 

Supervisor filters stores and stores filters county.I would like suprvisors to filter county.  My main issue is how to pass multiple ids to county. Since one supervisor can have stores in many counties. Any ideas or suggested post?

Here is a sample file https://drive.google.com/file/d/1SC0vDiZguIxVZ1aiCSqXbNyVKQtC_7Y7/view?usp=sharing

Thanks,

Rey

[V-lianl-msft · Accepted solution]

Hi @reynaldo_malave ,

Create a new "supervisor-county" table and create a one to many relationship with the county table. Then create a dynamic RLS in desktop.

After defining the RLS, you need to republish the report and assign RLS in the service

Refer to:https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple 

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

[reynaldo_malave]

Hi @V-lianl-msft ,

Thanks for taking the time. I already research radacad. My problem is different or maybe I am just not seeing it. I did prepare a samkple file if you can check it out i´d appreciated. I was trying to do something with pathcontains but it works with hierarchy and I am looking to do cross security depending on which supervisor have stores in the county.

 https://drive.google.com/file/d/1SC0vDiZguIxVZ1aiCSqXbNyVKQtC_7Y7/view?usp=sharing

Thanks, 

Rey

[V-lianl-msft]

Hi @reynaldo_malave ,

Unfortunately, I don't have access to the sample file.

In this forum, this thread appears solved.

https://community.powerbi.com/t5/Translated-Spanish-Desktop/RLS-con-la-misma-vista-de-nivel-para-las... 

If the problem persists,could you share the sample pbix again?

Please remove any sensitive data before uploading.

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

[reynaldo_malave]

hi @V-lianl-msft 

I did solve it with your advice. I don´t know why its duplicacted in spanish. I will accept your solution here as well.

Thanks,

Reynaldo