Forum Discussion
Shared Dataset RLS Not Carrying Through to Other Dataset
Hi thuetten
Can you confirm that the RLS is working as expected. Typically RLS does use relationships to work.
I would suggest testing with this blog post from Kasper to make sure you can understand how it works for your requirement.
Power BI Desktop Dynamic security cheat sheet - Kasper On BI
If I import the security dataset into my report as opposed to connecting to the shared one, RLS works as expected. The only difference between what I'm doing and in that article is that I have his 3 tables combined into one - users and their groups they have access to. So my relationship is many-to-many, which works if I have it imported into the pbi file.
Is there a limitation on that not working with direct query on the shared dataset? The only setting I can't enable that he did was the "apply security filter in both directions" - but again, I don't need that enabled on the imported version for it to work either.