Setting up Dynamic RLS

[rushi94]

Hi All,

I want to set up dynamic RLS in my report.Following is the structure

Fact table has site id column.I have user directory table which contains user emails alongwith site ids,some user ids have multiple site ids assigned to it.When I directly connect this active directory table to fact relationship becomes many to many.Hence I tried to create a bridge table of only one site id column with unique site ids but RLS is not getting implemented using bridge table.Could you please help if I am doing anything wrong?

[v-yanjiang-msft · Accepted solution]

Hi @rushi94 ,

By my test, many to many relationship doesn't affect the effectiveness of dynamic RLS, you don't need to create a new bridge table, here's my steps.

Fact table:

user directory table:

The two tables are related with the Site ID column.

Add a DAX filter in the Manage roles pane.

[User email] = USERNAME()

Now, I select View as to test the RLS, select New role and Other user at the same time and enter a email in the Other user option.

Return the correct result.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@rushi94 , This need to be many to many, you can filter from secure table to site table. if this bi-directional then you need, check the bi-directional security filter flag too

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk