Forum Discussion

juanjoseblancob's avatar
juanjoseblancob
Frequent Visitor
7 years ago

Slicer values with row level security

Hi!   I have the following issue. My report is basically driven by a slicer with all customer names, and this works fine for those of us with access to the full data set since we choose customers...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi juanjoseblancob,

 

Please check whether this porblem exists in desktop. If yes, please re-create the RLS and check again.

 

I cannot reproduce the same problem on my side. Please test my sample .pbix file on your side to see if issue persists.

 

Best regards,

Yuliana Gu

juanjoseblancob's avatar
juanjoseblancob
Frequent Visitor
7 years ago

Hi Yuliana.

 

Thanks a lot for your reply, and for the sample to test. Indeed, the problem does happen in the very simple file you sent. The key aspect to test it, though, is the following:

 

  1. Select a customer on the slicer (for instance, select X) -> this is the key step.
  2. Then change to a role that doesn´t see X (for instance, change to Role 2 which can only see Y)

You will see how the slicer still keeps X! If you don´t have anything preselected on the slicer (that is, if you don´t do step 1), then all works fine... but that´s not my scenario :(

 

Thanks in advance for your follow up.

 

Juan