Power BI - Row Level Security Issue

[AshokThiru]

In my current project , I'm facing an issues related to RLS. Even though I've given workspace access as Viewer for one user and I've added him in security group aswell , Still Row-level security is not functioning correctly. Instead of his data, the entire dashboard is still displayed.

[h21]

Hello, 

The main reason RLS is not working could be that, that perosn is having and edit permission first check for the permission. 

https://community.fabric.microsoft.com/t5/Service/Dynamic-RLS-does-not-work-in-Service/m-p/2941170#M...

For further, information you can read this, this is also regarding same issuse as you are facing. 

Best Regards.

If you find my answer helpful, then please mark it as solution. Thank You !

[Uzi2019]

Hi @AshokThiru 

Please try below video step by step and how to share the RLS report
https://www.youtube.com/watch?v=axTyP7I2Bso&t=314s

https://www.youtube.com/watch?v=N3XWKSVoRCQ

I hope It may resolved your issue!

[Alex87]

Hello,

Check your RLS conditions and test them them using "view as" function. Also, for which purpose you add the user to the workspace? You don t need to add users with RLS to the workspace. FYI, if the role to the workspace is above Viewer, it will override RLS.

If the answer does answers your needs, mark my reply as the Solution. If not, please provide additional information : sample of your data, rls condition in place. Thanks!

[AshokThiru]

Hello Alex,
Thanks for your response, I've tested it using "view as" function in desktop. Its working fine. but If i tested it in Power BI service using "test as role" in security in semantic model is not working. I've enabled the same workspace setting in new workspace is working. but old workspace showing incorrect data. I've given workspace access for users because we are embedded the report in D365 CRM.