Whereas utilizing RLS when Manipulating Relationships in Energy BI what can go incorrect? | by Salvatore Cagliari

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.

Photograph by Joseph Corl on Unsplash

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:

Part of MS Documentation about CROSSFILTER() and USERELATIONSHIP() and RLS (Figure by the Author)
Determine 1 — A part of MS Documentation about CROSSFILTER() and USERELATIONSHIP() and RLS (Determine by the Writer)

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?