Forum Discussion
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.
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
Table Column
Projects Project_id
Core_UserProject userid,Project_id
CostItem Project_id,cost_item_id
All other tables cost_item_id
Thanks
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
8 Replies
- lbendlinSuper User
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.
- ashmitp869Responsive Resident
Hi lbendlin
Is it not the correct data modelling ?
Fact tables are :CurrentBudget
TimePhasedBudgetTimePhasedForecast
ActualCost
Dimensions :CostItem
ProjectsPlease guide.
- lbendlinSuper User
Which table has the dynamic RLS mappings?
- ashmitp869Responsive Resident
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