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

Vicky_Song's avatar
Vicky_Song
Impactful Individual
10 years ago

Anonymous, did you check the same Power BI report when you do "Test data as role" and sign in as PBITEST002? The images you posted show that you're checking Power BI report when you do "Test data as role", however, you're checking with Power BI Dashboard when sign in as PBITEST002.