Forum Discussion
Row level security not working correctly
Hi,
Couldn't find that anyone had problem like me so asking for help.
Created a simple Role with name "PO Status" DAX formula: [Prod. Order Status] = "Released"
Tested this Role on PBI Desktop - works fine
Posted Dataset to PBI Service and assigned a "User Gruop" to this role - works fine, users can see Report as I wanted.
Problem: users who are not assigned to the Role but have acces to Report gets error: This visual contains restricted data To view this visual, contact the dataset owner to request access to the data behind it.
Where could be the problem?
Thanks in advance.
Vitalijus once you have RLS implemented, uses needs to be added to the RLS even if they have access to the reports until they have permission to edit the report, it is working as expected.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
3 Replies
Vitalijus once you have RLS implemented, uses needs to be added to the RLS even if they have access to the reports until they have permission to edit the report, it is working as expected.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
