Forum Discussion
Need assistance,guidance with Dynamic RLS
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
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
Core_Userproject is a fact table on the receiving end of the Projects dimension table. It doesn't control anything, making your RLS ineffective.
Your RLS table must control the rest of the data model to be effective.
Will you please provide me any solution or guidance - on how to implement the Dynamic RLS. ?
As Core_Userproject is the table where I get the information -
Which user has which project_id access.
ThanksChange the relationship to many-to-many and make it single direction from user to projects.