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

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

  • SnoJa10's avatar
    SnoJa10
    Advocate IV
    10 years ago

    I can confirm that I am using My Workspace and still get the problem. Any other ideas?

    • Parmezana's avatar
      Parmezana
      Frequent Visitor
      10 years ago

      SnoJa10 I saw nothing different in your syntax than what I used in mine so I will make sure I give you all the steps I took:

      1. what I am using is an uploaded .pbix file (where I used Import from an .xlsx with a datamodel in powerpivot) on powerbi instead of fetching data from .xlsx plain worksheets (this is important)

      2. The RLS should be tested with a coleague, not with your own account, owner of dataset can see all regardless of being part of an RLS restricted role.

      3. I shared my dashboard with a coleague whom I had entered into the said RLS role and he used the default icon showing up in the dashboard to access report.

       

      bspillar on your side, what other thing i can think of is that different tenants get updates at different times. you not being able to see the "Test data as role" makes me suspect your tenant hasn't been in an update wave.

       

      I hope this feature becomes more stable and more straightforward to use..

       

      BR,

      D

      • bspillar's avatar
        bspillar
        Advocate I
        10 years ago

        An update on my end... today when I went in to PBI I now see the "test data as role" option. Although, if I test the role it never seems to work as I get the 'x' boxes everywhere like others have posted. From my personal workspace, I can share a dashboard with RLS applied and it will work for a user. The same method will not work in a group workspace. A group workspace does not appear to apply RLS within the workspace. I can't create a content pack with the report that I added RLS to. I am not sure if that is the reason why or if it is something else causing an error.

         

        Just to note, when RLS originally worked for me it worked for my user name for testing, it worked in a group workspace for myself and other users, and it flowed through to a content pack (that was a nice surprse).

         

        Today's changes give me hope that developers are currently working on it. When RLS was working it was a very useful feature. It is just odd to see such a variance in user experiences.