Forum Discussion

JasonRoy's avatar
JasonRoy
Frequent Visitor
7 years ago

Very Strange Bug(?) - RLS Inconsistent Behavior, only working for certain users

Hello,

 

I'm currently working with a client of mine to clean up various reporting needs. I'm an external consultant and have been brought in to "pick up the scraps" so to speak. I have been looking into a very strange RLS issue since last Thursday and can't seem to put my finger on what's wrong.

 

To elaborate - I have a list of managers that need to see their respective employees' numbers. It works for some users but I have one user for certain whose RLS isn't working when SHE logs in. If I "Test as Role" with her username and correct RLS role I receive the correct results on both Power BI Desktop AND Power BI Service.

 

Additionally, there are two versions of this report. One of which where the user wants to see all of the data and the other which she wants to just her employees. Both of these reports have the EXACT same RLS roles defined and the user at-hand can only access data in ONE of those reports.

 

I've been playing around with different techniques and tests all to no avail. If any of you have experienced something like this and have some pointers, that would be greatly appreciated. I can provide more information if necessary. 

 

Thanks

Need Help

5 Replies

Replies have been turned off for this discussion
  • GilbertQ's avatar
    GilbertQ
    Super User
    7 years ago
    Hi there

    Could you see if the user has been added to any of the App Workspaces as a member or an Admin?

    Possibly they have been added as a member or admin in an App Workspace, and if it is V1 then the RLS will not be applied when they log in.
    • JasonRoy's avatar
      JasonRoy
      Frequent Visitor
      7 years ago

      I checked both workspaces and the only users in them are developers and, unfortunately, none of these users at-hand are developers. 

       

      Both workspaces are the old workspace experience. These users have dashboards shared with them and the reports that are attached to the dashboards shared with them. But they aren't members of any workspaces and no Apps have been published if that makes sense. 

      • GilbertQ's avatar
        GilbertQ
        Super User
        7 years ago
        Hi there

        If the user can upload to the workspace I would take an educated guess that they then have writes to upload, which would then give them Admin access?