Forum Discussion

bspillar's avatar
bspillar
Advocate I
10 years ago
Solved

Row Level Security No Longer Working?

Hi - I used the preview RLS feature on Tuesday and it worked exactly as described. Now today, I uploaded a new copy of my .pbix file and went to add my RLS rules and they are not working at all. It l...
  • bspillar's avatar
    bspillar
    10 years ago

    Another update: RLS is now working for me as described in the PBI documentation. I am able to apply the RLS in my personal workspace and distribute it via content pack to a user and it works! This is great and now I will just wait for the same functionality to be available in the group workspace :).

     

    Thanks!

     

    Brynn

bspillar's avatar
bspillar
Advocate I
10 years ago

Parmezana If I go the role name and click the ellipses "..." I only see "Rename Role" and "Delete Role". Is this where you are seeing the "Test Data as Role" option?

 

Parmezana's avatar
Parmezana
Frequent Visitor
10 years ago

bspillar Yup, here it is:

that is weird that you don't have that.

  • SnoJa10's avatar
    SnoJa10
    Advocate IV
    10 years ago

    So i tried the "Test data as role" option (on more than one dataset) and I just get a page full of errors that the data behind the visual cannot be displayed.

     

    Again using very simple syntax and tried all possible combinations. So RLS still not working at all for me.

     

     

     

     

    • Parmezana's avatar
      Parmezana
      Frequent Visitor
      10 years ago

      SnoJa10 Hey,

      it did that to me as well first few times i tried. can I see your DAX formula?

       

      BR,

      D

      • SnoJa10's avatar
        SnoJa10
        Advocate IV
        10 years ago

        Sure, below is the simple DAX i have applied. I still get the error.

         

  • bspillar's avatar
    bspillar
    Advocate I
    10 years ago

    Yes it is weird... and now that you mention it, I think I remember having that option when it was working so this may be a relevant observation.

    • Parmezana's avatar
      Parmezana
      Frequent Visitor
      10 years ago

      SnoJa10 Excact same type of filter with mine. So one day it might just work randomly :(

      another note:

       

      at https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/

      I see in the limitations a line as:

      "Defining RLS in a group workspace is not supported"

       

      any of you trying under this type of workspace?

      I will try on my personal and share from there with a coleague and revert back to you :)

       

      BR,

      D

      • Parmezana's avatar
        Parmezana
        Frequent Visitor
        10 years ago

        Ok all,

        it is as explained. applying RLS on a dataset within my own workspace and then sharing the dashboard worked.

        it will not work currently in a Group workspace.

         

        BR,

        D