Row Level Securit

[hjambretz]

I am having problems with RLS.  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,

Hollie

I have 3 tables

     Table                            Columns

1. Applications                 applictionID, studycenterID

2. StudyCenters                studycenterID

3. StudyCenterUsers         email, studycenterID

Defined Relationships

Applications/StudyCenters on studycenterID

StudyCenter/StudyCenterUsers on studycenterID

My dax filter is on StudyCenterUsers where email=UserName()

='Study Center Users'[email]=USERNAME()

[Pragati11]

Hi @hjambretz ,

Can you share your sample data rows here along with the relationships you have among your tables?

Thanks,

Pragati

[hjambretz]

Here's my data

[hjambretz]

Sorry!  the Relationships are

Applications/Study Centers on studycenterID

StudyCenterUsers/StudyCenter on studycenterID

[Fowmy]

@hjambretz 

Please refer the following links on how the RLS is implemented 

https://www.youtube.com/watch?v=MxU_FYSSnYU
https://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