Row level security on multiple tables linked to one table

[kb_barge]

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.

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.

Please tell me a workaround for this. Thanks in advance. 

[Icey]

Hi @kb_barge ,

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 Regards
Icey

[Icey]

Hi @kb_barge ,

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.

Best Regards,

Icey

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

[kb_barge]

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

Thanks

[Icey]

Hi @kb_barge ,

I think the end is similar.

If you don't mind, please give me some sample data, I will test it specifically.

Best Regards,

Icey