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

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

    • 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