Row level security does not appear on dashboard but yes for preview role.

[nchandran]

Hi,

I've created a dashboard in BI service and then applied changes to my dataset with setting RLS to a role. After publishing and see as preview under the role - i could see the correct filter however when i exit out and get the user(the role user) to access the dashboard the user is able to see everything without the RLS applied. Is there something i've missed out?

[Anand24]

@nchandran,

Make sure your user is assigned with "Viewer" role in the workspace.

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[nchandran]

we hve granted access to the staff on a premium workspace.

and i've shared the dashboard to those staff.

[Anand24]

Hi @nchandran ,

The user on whom RLS is applied should be having "Viewer" Role even if the workspace is premium workspace.

RLS doesn't work with any other role.

Go to workspace access and confirm if the user is having viewer role/permission or not.

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[nchandran]

The user has viewer access. What else should we check to get this working?

[V-pazhen-msft]

Hi @nchandran 

Have you figured out your issue, I am curious is there any additional conditions required to make RLS working.

Regards
Paul

[nchandran]

the user has viewer access and its not working so i've tried this instead mapping an id to the powerbi account (trying dymanic RLS) but this isnt working either. A new column called bill owner was set and this will map to the powerbi account but it doesnt work either.

[V-pazhen-msft]

@nchandran 

This is so weird, I could not reproduce that issue with my tests. Try recheck and follow the RLS tutorial step by step carefully. If still no solution, you can create a support tickets. 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nchandran · Accepted solution]

Even though i moved to Dymanic RLS, the solution didnt work because the location where the report was created and published was on te App workspace and i didnt have the admin privillege. MS ticket was raised and the we managed to elevate my permission to admin then i was able to change the access of those shared with the report to viewers only. This fixed the issue.

Owner or member will not work for RLS. Take note ppl.

[V-pazhen-msft]

@nchandran 

Did you add the users to the RLS group is created. And Only Import and DirectQuery connections are supported. Live connections to Analysis Services are handled in the on-premises model.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.