Forum Discussion
Anonymous
4 years agoNot applicable
User has access even after removing access
Hi All, Not sure what the issue is here but let me try and explain the issue. I have this issue with multiple users but will give an example for one user. A user has access to a Power BI work...
Marek_K
3 years agoFrequent Visitor
Did you find a solution for it? Or somebody else? Or some workaround? I have the same problem.
For new users the access works properly, but for previous users it doesnt work properly (they have only view access. Access was refreshed several times). Also in desktop application RLS access works ok.
It is stragne that if I "test as a role" for previous users, the function USERPRINCIPALNAME returns my email, but for other users it returns other user emails.
- VamsiBh2 years agoNew Member
Did you find any solution to this problem?
- Marek_K2 years agoFrequent Visitor
hi,
I found solution. I had many to many relation used in RLS.- Before: table A - table B (many to many),
- after: table A - additional table (many to 1), additional table - table B (1 to many)
And it works now