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

      • ankitpatira's avatar
        ankitpatira
        Community Champion
        10 years ago

        Anonymous we have to troubleshoot this further. In Test Data as Role, you can also enter individual email address and preview for that, so enter PBITEST002 email address and check what it shows you in preview.