Forum Discussion

juanjoseblancob's avatar
juanjoseblancob
Frequent Visitor
8 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
Icon for Microsoft Employee rankMicrosoft Employee
8 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
    8 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

    • juanjoseblancob's avatar
      juanjoseblancob
      Frequent Visitor
      7 years ago

      Hi again! I could finally get back to my PowerBI community account after all the mess with associating non-organizational and organizational accounts :(

       

      Were you able to replicate this Yuliana? Should I report it as a bug?

       

      Cheers,

       

      Juan

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        7 years ago

        Hi juanjoseblancob,

         

         Please review the response from PG:

         

        By Design. RLS causes a Table-level filter based on the role, it does not update any slicer visuals. It is an "invisible" filter applied to every query that is generated.

         

        Best regards,

        Yuliana Gu

  • santiagomur's avatar
    santiagomur
    Icon for Resolver II rankResolver II
    7 years ago

    hi, 


    on this file happens, if you select X and then the selec the role 2 you see the X and the Y, if you deselect the x it disappear but the need is they happens when the role change.

     

     

    v-yulgu-msft 

     

    regards