Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
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
Hi @reynaldo_malave ,
Unfortunately, I don't have access to the sample file.
In this forum, this thread appears solved.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |