Forum Discussion
RLS modeling for dynamically filtering
Have an RLS dynamic filtering question
Have the user email along with the Divisions that users can see the data in following format.
| Location | Division 1 | Division 2 | Division 3 | Division 4 | |
| EAST | [email protected] | ABC Div | XYZ Div | 123 Div | |
| EAST | [email protected] | ABC Div | XYZ Div | 123 Div | NEW Div |
| SOUTH | [email protected] | 777 Div | 555 Div |
Fact has GI's for divisions . [email protected] should see only the qty of 50 for 3rd Oct. How can i filter in RLS for all various divisions based on email.
| GI No | Date | Qty | Division |
| 1000 | 1-Oct-21 | 25 | XYZ Div |
| 1001 | 3-Oct-21 | 30 | ABC Div |
| 1002 | 3-Oct-21 | 20 | ABC Div |
| 1003 | 15-Oct-21 | 70 | 555 Div |
| 1004 | 15-Oct-21 | 50 | 123 Div |
| 1005 | 20-Oct-21 | 100 | NEW Div |
on the Access Grp, i used email = USERPRINCIPALNAME(). Struck on dynamic filtering of location and divisions.
Pbix is https://drive.google.com/file/d/1LKEIZmqAghp-El47AB_r0uWo0nWEbuCp/view?usp=sharing
2 Replies
Anonymous , You have to unpivot the first table to bring division in rows to use RLS on division
Thanks amitchandak . I did unpivot them. But my question was on how filtering can be done dynamically
