Forum Discussion

Pat_learner's avatar
Pat_learner
Frequent Visitor
9 years ago
Solved

RLS - At a group level

Hi, I would like to set up RLS at a team level since each team have access to different forms.  I thought the problem I'm trying to solve is pretty simple.  I have 2 tables.     Table#1-'Rep-Produc...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    Pat_learner

     

    1. what did I do wrong with the set up.

     

    If you need to detect team belonging for all access users, it's better to have a Team-User Table. Otherwise you need to create one role for each Team.

     

    2. Is it possible to just set up DAX filter on the 'Team One' role to just list valid forms for 'Team One'. 'REP-Products'[ProductId]= (A,B)

     

    You can directly use row level filter expression like:

     

    'REP-Products'[ProductId]= A || 'REP-Products'[ProductId]= B

     

     

    Rergards,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

Pat_learner

 

1. what did I do wrong with the set up.

 

If you need to detect team belonging for all access users, it's better to have a Team-User Table. Otherwise you need to create one role for each Team.

 

2. Is it possible to just set up DAX filter on the 'Team One' role to just list valid forms for 'Team One'. 'REP-Products'[ProductId]= (A,B)

 

You can directly use row level filter expression like:

 

'REP-Products'[ProductId]= A || 'REP-Products'[ProductId]= B

 

 

Rergards,