Forum Discussion
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 workspace (Member access). This allows the user to see and access all reports in that workspace.
I wanted to setup a report in that workspace with RLS. Since this user had workspace level access RLS does not work and the user can see all the data in the report just like admin access. So i removed the users workspace acess and tested the RLS the user is still able to see all data. I have not granted user access to the report or dataset and yet the user has access
Seems like even when i remove the users access at workspace level they are still able to see all reports. There are no DL's also that is added with Workspace access.
What can be causing this issue and how can I rectify this issue since i have already removed the workspace level access yet the user has acces to the workspace. Something is not in sync.
Thanks in advance for your support
19 Replies
Hi,
Was your case solved? Unfortunately I have the same issue. The user has no access to workspace, report, dataset, anything but can access data even protected by RLS to which user has no access.
Thanks for the help!
I am also experiencing this. Trying to secure the analyze in excel functionality to limit access to data model. User can't access data model. I grant them workspace access, they can now access data model. I remove their workspace access, can still access data model. Very concerning.
Any solution here?
Hi, Anonymous
Be aware that RLS anyway doesn't take effect for users with Admin, Member or Contributor roles.
We have to make sure that the operation of row-level security is correct.
Row-level security (RLS) with Power BI
In addition, I’m not sure if this is related to service updates. I saw in the issue forum that other people have also posted related issues about row-level security. You can check if there are similarities in your situation.
Security roles not working properly after Fall 2021 update
If the operations of row-level security are correct, and your situation is not similar to their posted issue situation, then you could try to post your issue, and more, you could create a support ticket, which will be free If you have Pro(PPU) account. Go to https://support.powerbi.com, Scroll down and click "CREATE SUPPORT TICKET".
Best Regards,
Community Support Team _ Zeon ZhengIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-angzheng-msft thanks for your response
What i noticed also is, if a person who has not been part of the workspace then RLS works for them.
So the issue is only when removing a persons access from workspace. Thought the user does not show up in workspace access they still have access probaby because of some sync issue in backend
Not sure how adding and removing users work in power bi in the backend.
Hi, Anonymous
There may be network delays and web cache here, please try to log out of your account and log in again, or log in again in the privacy window
In the service, click on the report's three-dot menu, select Manage Permissions, and then view and manage users with access rights in the interface
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.v-angzheng-msft Been a week since i had this issue and since then logged in and logged out many time.
Regarding Manage Permissions, the user does not show up there yet the user has acccess to the report. User also does not show up under workspace admin nor any group is part of the workspace or report.
Hi, Anonymous
That’s weird, not sure if it’s related to the service update.
You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
Or you could try to create a support ticket and see if Microsoft Support can help you, in my experience they are pretty good at getting back to you in a timly manner.
If you have a Pro account it is free. Go to https://support.powerbi.com, Scroll down and click "CREATE SUPPORT TICKET".
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.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.
Hello there,
Did you find the solution to your issue here? I have the same issue happening suddenly since today morning, not sure how to fix it. Any help would be highly appreciated.
Having the same issue. This is 2024 , I have seen some of the user from 2021 having same issue. Did anyone find a solution or anything at all?
Found out that it's when using the share option , it generate a link which by default share it with people in your organization .
On power bi report :
When clicking share chose other option than the default one :
How to remove it when it's already share :
Go in manage permission , links and delete the link
Hope it helps 🙂
Cheers
Pravesh
