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

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi Adam,

 

Where did the filters work for you? Did they work at the time of testing, within the dataset security where you have the feature to 'test as role'? or did it work for you in an actual report? I have added screenshots (below) where I expect to see pbitest002 user to see only Central District, but the user can see all districts.

 

How can I log a support ticket? I have just tested out RLS after June 2016 update, and it has not changed a bit for me.

 

1 - Implementing RLS and testing it on Desktop (June 2016)2 - Configuring RLS in cloud (post publish) and adding users to role3 - Viewing as the end user

 

 

Thanks


Kaz

Anonymous's avatar
Anonymous
Not applicable
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