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
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.
Thanks
Change the relationship to many-to-many and make it single direction from user to projects.