Row Level Securit

Question

I am having problems with RLS.&nbsp; When I log in as one of the StudyCenterUsers, it doesn't filter down the data to only the Study Centers defined for the User.I appreciate any/all help with this!!Thank,HollieI have 3 tables&nbsp; &nbsp; &nbsp;Table&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Columns1. Applications&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;applictionID, studycenterID2. StudyCenters&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; studycenterID3. StudyCenterUsers&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;email, studycenterIDDefined RelationshipsApplications/StudyCenters on studycenterIDStudyCenter/StudyCenterUsers on studycenterID&nbsp;My dax filter is on StudyCenterUsers where email=UserName()='Study Center Users'[email]=USERNAME()

fowmy · Answer

hjambretz&nbsp;Please refer the following links on how the RLS is implemented&nbsp;https://www.youtube.com/watch?v=MxU_FYSSnYUhttps://www.youtube.com/watch?v=uyxesN_nGnQ________________________Did I answer your question? Mark this post as a solution, this will help others!.Click on the Thumbs-Up icon if you like this reply 🙂YouTube, LinkedIn

pragati11 · Answer

Hi&nbsp;hjambretz&nbsp;,
&nbsp;
Can you share your sample data rows here along with the relationships you have among your tables?
&nbsp;
Thanks,
Pragati

hjambretz · Answer

Here's my data&nbsp;&nbsp;

hjambretz · Answer

Sorry!&nbsp; the Relationships areApplications/Study Centers on studycenterIDStudyCenterUsers/StudyCenter on studycenterID

Forum Discussion

Row Level Securit

4 Replies

Related content

Dynamic Row level security

Dynamic Row level security issue

Row level security

Row Level Security

Row Level Security