USERELATIONSHIP Ignoring RLS with Inactive all Relationships – Bug or Feature?

[IsFea]

Hello, I have a question about how USERELATIONSHIP works when all relationships are initially deactivated.

As an example, I have prepared a simple data model (all relationships are deactivated!):

dimproduct:

factonlinesales:

I have set up a simple RLS role.

Without using USERELATIONSHIP, I only see Deluxe products:

Since RLS filters my dimension table. Great!

However, when I add USERELATIONSHIP:

I start seeing Economy products!

Can someone explain why this happens? It looks like a bug because I expected to get the sales total only for Deluxe.

Yes, I understand that RLS propagates through active relationships, but there are no active relationships in my model!

I want to filter my dimension table using RLS, and I expect this filtered dimension table to also filter my fact table.

[Rupak_bi]

Hi,

Userrelationships also works as active relationships only and will bypass RLS. To enable RLS, you need to define the same in the DAX where using Userrelationship.