When we’ve got RLS in place, there are some restrictions after we attempt to manipulate Relationships. Nonetheless, Microsoft’s documentation doesn’t present many particulars on this matter. So, let’s dissect this. You’ll expertise a giant shock.
In DAX, after we wish to manipulate Relationships between tables, we are able to use certainly one of these features:
We will discover the next sentences within the Microsoft documentation concerning the interplay between these two features and RLS:
Whereas the sentence is unclear for CROSSFILTER(), it’s a lot clearer for USERELATIONSHIP():
These features don’t work appropriately when manipulating relationships between tables affected by RLS guidelines.
However what does this imply?