Does RLS Restrict slicer values as well as the data

[MikeBresnan]

I'm just starting to look into using RLS, and one of my first tests seems to be working really well with the data restriction. Only data relating to the allowed "entity" values are displaying in the report. However, if the user opens the multi-select slicer drop down, the restricted "entity" values still show. If selected, no data returns, but i'd like to restrict that value completely if possible.

Or does RLS only apply to the data returned?

[Jonvoge · Accepted solution]

Hi MikeBresnan

It depends on your data model, and how you have restricted the data.

Are you using a Star Schema data model?

If your RLS is filtering one table, but your Slicer is populated by another table, the Slicer will still show all values. However if you ensure that your Slicer is being populated from the same table which is filtered by RLS, the Slicer values should be filtered as well.

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

[MikeBresnan]

That was my exact issue! thanks!!!