Row level security on multiple tables linked to one table

Question

Hi,I have a customer table linked to three tables viz. Budget, Transactions and Open Orders through bridge tables.And there's both sided many-to-one relationships. Hence, I am only able to turn on row level security filter for only one of the three tables.&nbsp;For eg, when I turn on RLS filter on the sales table and I create roles, only sales get filtered and not budget or open orders.&nbsp;Please tell me a workaround for this. Thanks in advance.&nbsp;

icey · Answer

Hi&nbsp;kb_barge&nbsp;,You can refer to these articles:Dynamic Row Level Security with Power BI Made Simple,Dynamic Row Level Security in Power BI with Organizational Hierarchy and Multiple Positions in Many-to-Many Relationship – Part 1,Dynamic Row Level Security in Power BI with Organizational Hierarchy and Multiple Positions in Many-to-Many Relationship – Part 2.&nbsp;Best Regards,Icey&nbsp;If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

kb_barge · Answer

Hi&nbsp;Icey&nbsp;,Thanks for your reply.But the problem I have is kind of different. I suggest you to read the question again.&nbsp;Thanks

icey · Answer

Hi kb_barge&nbsp;,I think the end is similar.If you don't mind, please give me some sample data, I will test it specifically.&nbsp;Best Regards,Icey&nbsp;

icey · Answer

Hi&nbsp;kb_barge&nbsp;,Is this problem solved?If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.If not, please let me know.Best RegardsIcey

Forum Discussion

Row level security on multiple tables linked to one table

4 Replies

Related content

Lakehouse table security

Onelake security with large tables

Table Level Security

regarding storing multiple tables in lake house

Role Level Security