Dynamic RLS role creation based on role name

[RafDelgado]

Hi All, 

Is it possible to have a dynamic RLS role filter based on the role name itself?

So for example:

Role name = '1677217'

Table filter:  ID = [Role name]

Or

Role Name = 'New York'

Table Filter: City = [Role Name] (so New york)

Thanks,

Raf 🙂

[v-lili6-msft]

HI, @RafDelgado 

You could try to use conditional that logic as this formula to add a RLS

IF(ISERROR(VALUE(USERNAME())), [City] = USERNAME(), [ID] = USERNAME())

Result:

Basic dataRole name = '1677217'Role name = 'A'

Here is pbix file. please try it.

Best Regards,

Lin

[RafDelgado]

Hey @v-lili6-msft , 

Thanks so much for the reply. 

I think I may not have explained it properly, What I would like is something like the below.

 

But instead of the DAX expression being filtered on the manually typed 16777217, it uses the name of the role instead.

 

Meaning I could have mutliple roles with different number ids for what I want to filter but not have to go through each table to change the query.

[rvgfox]

I have the same issue. Did you solve it?

[v-lili6-msft]

hi, @RafDelgado 

You could refer to this blog:

http://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi

Best Regards,

Lin