RLS Not working

[vasathi]

Team

i'm working on the RLS for multi dimension & fact tables

i can able to test RLS in view role, but after published this RLS not working. i have added the required user in Dataset in the portal also.

Below is screen

Seeking your help

[v-xulin-mstf · Accepted solution]

Hi @vasathi

Does RLS not work for all users, or only for some users?

The RLS will be applied to the read-only members.

If they are marked to have edit rights, the RLS will not be applied.

Please refer to the official documentation.

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[aj1973]

Hi @vasathi 

What do you mean by adding the user to the Dataset? The user needs to be existing in the source DB, and has an account in Active Directory

[vasathi]

Dear AJ

i mean user has been added in the Dataset security

As you said users are in DB as well as active directory

[aj1973]

What is the message the user receives when he opens the report?

[vasathi]

There is no error; datas are not filtering as per the roles. But it is working in desktop as well as working when we test 

hope you clear my questions

[aj1973]

You are not answering my question!!

You can't test the report in the service like you test it in the desktop. So add yourself as a Member of that RLS group, try to open the report int the service. Or if a user is trying to open the report and not working for him then what is the message he receives.