Forum Discussion

ap's avatar
ap
Advocate I
8 years ago
Solved

Multiple Roles RLS? Can I have one user have multiple roles that are cross filtered but independant

Example, is it possible to have a sales manager I have a mapping table that shows me region and type of sales. Fake scenario here. This is fine when I am applying roles to regional managers (US, Ca...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi ap,

     

    So your requirement is two create a manager role which can see either contents which are belong to Canada Manager or contents which are belong to Books Manager, right? You should multiple columns(e.g.: [Common Manager], [Grand Manager]). For more info or details, refer to this blog: Dynamic Row Level Security with Organizational Hierarchy Power BI.

     

    Hope it's helpful to you.

     

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi ap,

 

So your requirement is two create a manager role which can see either contents which are belong to Canada Manager or contents which are belong to Books Manager, right? You should multiple columns(e.g.: [Common Manager], [Grand Manager]). For more info or details, refer to this blog: Dynamic Row Level Security with Organizational Hierarchy Power BI.

 

Hope it's helpful to you.

 

Jimmy Tao