Row level security with multiple roles

[rolf1994]

Hi,

Is it possible to use different Roles in Power BI Embedded for RLS? for example: on some of our reports we want RLS to apply on OrganisationId and for some reports we want RLS to apply on UserId. Maybe this is possible based on a role name?

Thanks in advance.

[v-shex-msft · Accepted solution]

HI @rolf1994,

You can link user table and organisations table, then turn on the 'apply security filter in both directions' option and modify the 'cross filter direction' option to 'both' at manage relationships.

Then create two roles(one on organisation id, another based on user id), setting the specific one to users who needed.

Regards,

Xiaoxin Sheng