RLS Not working in APP

[Harryy090]

Hi, 

I am trying to implement the RLS for the first time. I can see the RLS is working at the workspace level where we can use the Test role option. it doesnt work when published to App. Any help is much appreciated. 

Does the workspace needs to be of Premium capacity for the free user to see the 

[Harryy090]

looks like the users I had this testing for had some other high level permissions that were overriding the setttings when applied individually. Tried this on a new dummy user and it all works fine. Thanks for all your support

[Harryy090]

@amitchandak thanks for the reply. I have already added the user to the role in the workspace using the email address. The user's role is also set to viewer in workspace access. 

The workspace is not of premium capacity and also the user does not have a pro licence, does it have any effect on what I am trying to do?

[amitchandak · Accepted solution]

@Harryy090 , In workspace, you have to add users to security 

On three dots of dataset line, you have an option for security

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk

RLS - Row Level security
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns...
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi