Forum Discussion
RLS with multiple conditions
- 1 year ago
showy , This is because RLS is doing and for both and you are not getting data. We can not change RLS based on Page, we can do based on user.
On quick solution can be
In this can you can create a two measures based on userprinipal and use them as visual level filter and hide filter pane from user. and that can give filter based on table you wnat on each page
Hello Sahir,
yes all the 3 point you are mentioning are correct im my model. But if i go to Show AS and select the user and role i get no data
showy , This is because RLS is doing and for both and you are not getting data. We can not change RLS based on Page, we can do based on user.
On quick solution can be
In this can you can create a two measures based on userprinipal and use them as visual level filter and hide filter pane from user. and that can give filter based on table you wnat on each page