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
Please redesign your data model first. Implement a Star schema, and place the RLS dimension table on the outskirts so it can control the fact tables in the center.
Hi lbendlin
Is it not the correct data modelling ?
Fact tables are :
CurrentBudget
TimePhasedBudget
TimePhasedForecast
ActualCost
Dimensions :
CostItem
Projects
Please guide.
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
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.