Forum Discussion

BforByron's avatar
BforByron
New Member
7 years ago
Solved

RLS user issue

Hello, I am having some issues with RLS in my report. I am sharing a report with various world wide users and need to keep the information limited to each user’s area of responsibility. I have se...
Need Help
  • GilbertQ's avatar
    GilbertQ
    7 years ago
    Hi there

    I was referring to the classic workspace in that there was a known bug even if the users had READ-ONLY access they could still see all the data.

    This has only been fixed with the New App Workspace and the Viewer role.
BforByron's avatar
BforByron
New Member
7 years ago

Hi Dina,

The report is shared in a team workspace that all the users are members of. I am not the owner of the workspace but I do not believe these users would have any access beyond read only due to their positions. Could be possible.

This is just static RLS, I set up the roles and defined the views using the DAX input then added the users to the roles in the dataset. 

This is the only report based on this dataset and all these users are new to it.

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

If the users are members for the Classic Workspace, even with read-only access they will still see all the data.
  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    7 years ago

    Hi GilbertQ ,

     

    I think you should refer to New app workspace rather than classic workspace. 

     

    For new app workspace, RLS works when the role is viewer. Anyone with Member/Contributor/Admin ignore RLS.

    For classic workspace , RLS works when the role is read-only member. Anyone in the workspace with Write access will ignore RLS.

    Hi BforByron ,

     

    I would suggest you to set the report based in your own workspace, and try again. if the issue still exist, please raise your ticket to https://powerbi.microsoft.com/en-us/support/

     

     

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

      I was referring to the classic workspace in that there was a known bug even if the users had READ-ONLY access they could still see all the data.

      This has only been fixed with the New App Workspace and the Viewer role.
      • v-diye-msft's avatar
        v-diye-msft
        Community Support
        7 years ago

        Hi GilbertQ ,

         

        Oddly, I've just tested the RLS under read-only role in classic workspace, it works great as always!

        Could you please test it in your side ?

         

         

    • BforByron's avatar
      BforByron
      New Member
      7 years ago

      Due to workplace restrictions I can not create a new workspace. Is there anyway to implement this on the existing workspace?

       

      Is there anyway to implement RLS on users who are members of the workspace?

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

        As I understand it, you would need to move to the New App Workspace to allow members with the Viewer Role to have RLS applied.

        The only other option is to remove the users as members from the current Workspace.