Forum Discussion
Solved
Need assistance,guidance with Dynamic RLS
Hi , I need some guidance with Dynamic RLS. Attaching the sample pbix file https://github.com/suvechha/samplepbi/blob/main/sample_info%20-%20security.pbix Sharing the sample data model. ...
Please see another post where its sharing the solution.
https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-RLS-with-User/td-p/4592040
Which table has the dynamic RLS mappings?
Projects having Project_id is linked to Core_UserProjects.
I am using Dynamic RLS in the Core_UserProjects which has got email id of user.
User = [Email] = USERPRINCIPALNAME()
The security of this model should be.
Userid 9 should only view the projectid assign to the user i.e 1 and 5
Userid 7 should only view the projectid assign to the user i.e 1