Forum Discussion

rajulshah's avatar
rajulshah
Resident Rockstar
5 years ago
Solved

Alternative to USERELATIONSHIP & CROSSFILTER for RLS

Hello everyone,   I have RLS in my dataset and there are couple of inactive relationships in our dataset. Microsoft document says that USERELATIONSHIP wouldn't work when RLS is applied. We are achi...
General Comment
Interesting Links
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI rajulshah,

    I think you are misunderstanding with RLS features, it can be worked with 'USERELATIONSHIP' functions.
    I think the relationship part which you mentioned is mean the indirectly cross table filter features, it is based on active relationships.
    If tables did not exist relationship link to the raw table, the RLS filter not auto-apply to those tables. You need to manually set filters on these inactive relationship tables.

    Regards,

    Xiaoxin Sheng

  • rajulshah's avatar
    rajulshah
    Resident Rockstar
    5 years ago

    Hello parry2k ,

     

    Unfortunately I won't be able to display the model, but I am getting the same issue as the issue mentioned in this post.

     

    Also, this link show you that USRRELATIONSHIP cannot be used when RLS is applied on the table.