Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Dynamics RLS rules conflict



I have tried to provide a rudementary example of a data model to describle the scenario, below.


In short, we have implemented dynamics RLS.

Each role works individually, but when I enable both they conflict as there is effectively an overlap.


The problem / access I am trying to solve is that a user should only be able to see data for their businessunit but effectively two different ways, they can see:

1. any opportunity data owned by their business unit and any invoices related to these opportunities, AND

2. all invoices owned by their business unit and any opportunities relating to those invoices


As mentioned, I have created roles that individually work, but due to the relationship between opportunities and invoices, the filters once both enabled effectively create an error.


I presume the only way to address this is some form of DAX formula, but I don't know how.


I can confirm that I can create static RLS for the scenarios, and apply the two static roles per business unit, but as there are around 30 business units, two roles each, and hundreds of potential users it's an exceptional admin overhead to manage.


Any thoughts or recomendations would be much appreciated.


Thank you.





Super User
Super User

Highly recommend you watch the replay of today's Power BI Dev bootcamp session when it comes out.

Session 18: Developer Deep Dive into Row Level Security (RLS) · Power BI Dev Camp (powerappsportals....

Thanks for sharing. Is it usually available soon after?

yes, check back in a day or so.

Helpful resources

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!