Forum Discussion

MikeBresnan's avatar
MikeBresnan
Helper I
2 years ago
Solved

Does RLS Restrict slicer values as well as the data

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 ...
Need Help
  • Jonvoge's avatar
    Jonvoge
    2 years ago

    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

Jonvoge's avatar
Jonvoge
Most Valuable Professional
2 years ago

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's avatar
MikeBresnan
Helper I
2 years ago

That was my exact issue! thanks!!!