Forum Discussion

Scocal123's avatar
Scocal123
Helper I
3 years ago

Crossfilter and row level security

Hello,   I have the following model for a report: I've been asked to implement RLS and I'm having some trouble figuring out the correct method.    In my original model table 1 does not exi...
crossfilter
modelling
Row Level Security
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Scocal123,

I'd like to suggest you check the relationship direction to confirm these filter effect can correctly apply through these table relationship mappings.(single direction relationship only work on one side, you may need to modify some of them to both direction)

What is the Direction of Relationship in Power BI? - RADACAD

Regards.
Xiaoxin SHeng

Scocal123's avatar
Scocal123
Helper I
3 years ago

Thank you for the response.

I have tried your suggestion. In the example above, when I use 'View as role' to check the RLS, I can see that table 1 filters to 2 rows with 2 IDs which is correct. These 2 IDs from table 1 succesfsully filter table 2. I have set the relationship direction to 'both' between table 2 and 3, but it does not perform any filters on table 3 and I am struggling to understand why. Any advice would be appreciated. 

Kind Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    HI Scocal123,

    It sounds strange, I'd like to suggest you extract these three table to a standalone report to exclude other filter effects and try again.

    Regards,

    Xiaoxin Sheng