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,
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.
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
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.
Hi @Icey ,
Thanks for your reply.
But the problem I have is kind of different. I suggest you to read the question again.
Thanks
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
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |