Forum Discussion
Show restricted Data on filter panel
Do you have a proper relationship configured between the main table with RLS and the Dimension1 table?
In my environment this is working as intended, users can only filter to records they have access to, they can't see other records in the filter pane.
One workaround that comes to mind is can you remove the filter pane and add a slicer to the report itself, that should get around this, but I'd love to get to the bottom of what is actually happening.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Do you have a proper relationship configured between the main table with RLS and the Dimension1 table?
In my environment this is working as intended, users can only filter to records they have access to, they can't see other records in the filter pane.
One workaround that comes to mind is can you remove the filter pane and add a slicer to the report itself, that should get around this, but I'd love to get to the bottom of what is actually happening.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Alright !
Thanks to your answer, I found what was the issue :
-Dimension1 is present in two tables : the facts table, and a dimension table.
-RLS is applied on Dimension1 in the fact table, but it is Dimension1 of the dimension table that was put in the filter pane.
-If I recreate the role on Dimension1 of the dimension table (single direction relationships from Dimension table to Facts table), I only get the role value in the Filter Pane.