Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Row Level Security (RLS) on SQL Server data

Hi everyone,    I am trying to give RLS a test but not getting anywhere when end users access reports & dashboards. Here's what I have set up, and done.    Data:  Data is coming from SQL Server ...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi Adam, and everyone, 

     

    I finally got it t work. the reason why RLS was not working as expected, was that the role member (PBITEST002) was configured as an admin of the workspace. RLS started working as expected once I set pbitest002 as member.

     

    Thanks

     

    Kaz

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

Anonymous When you created role in RLS did you added your user PBITEST002 under Members tab ? Follow steps listed in this post. 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    ankitpatira Yep, I did add PBITEST002 to the role members list. 

     

    Thanks

     

    Kaz

    • ankitpatira's avatar
      ankitpatira
      Community Champion
      10 years ago

      Anonymous Try this,

       

      in your DAX you don't need to mention table name. so your dax should be [Column]="PBITEST002"

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        ankitpatira Thanks Ankit. I tried using just the column name, and still does not work.. PBITest002 is still able to see rows for PBITETST001, though it works well at the time of testing RLS. 

         

        Thanks

        Kaz