Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I want to revoke user access to a dataset using REST APIs. According to the documentation, I can use this API endpoint with `datasetUserAccessRight: None` to remove all the dataset permissions of the specified user.
Upon using this API endpoint, I get a 200 successful response, but the user still has access to the dataset. I also tried refreshing the user permissions as mentioned here.
Is there a bug in the API itself or is my request wrong?
EDIT: This issue happens only when I first grant access to a user via this API endpoint. After this, I can confirm that the user has been given the permissions using this API endpoint as well as by manually checking in PowerBI under Manage Permissions. Now, if I try to revoke access using this API endpoint, the user permission IS removed when checking using this API endpoint as well as in PowerBI Manage Permissions. However, the user still has access to the dataset.
SOLUTION: There was a link configured for the dataset that allowed Read access to everyone in the organization. Thus, even though I revoked the permission individually for the user, they were still able to view because of the link. Removing the global read access link solved the issue.
headers = {
'Content-Type': 'application/json',
'Authorization': f'Bearer {access_token}'
}
api_url = f'https://api.powerbi.com/v1.0/myorg/groups/{group_id}/datasets/{dataset_id}/users'
share_details = {
"identifier": user,
"principalType": "User",
"datasetUserAccessRight": "None"
}
response = requests.put(api_url, headers=headers,
data=json.dumps(share_details))
Solved! Go to Solution.
SOLUTION: There was a link configured for the dataset that allowed Read access to everyone in the organization. Thus, even though I revoked the permission individually for the user, they were still able to view because of the link. Removing the global read access link solved the issue.
SOLUTION: There was a link configured for the dataset that allowed Read access to everyone in the organization. Thus, even though I revoked the permission individually for the user, they were still able to view because of the link. Removing the global read access link solved the issue.
Hi @gautamj
Are you the Dataset owner? Do you have all rights on the folder of the dataset? Please read the limitations of the API you might fall into one of them
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
I've updated my post. I am able to remove the user permissions, but it looks like the user still has access to the dataset.
did you wait the recommended two minutes?
Yes, the user is indeed removed from the list of users with access to the dataset under Manage Permissions in PowerBI. However, the user still has access to it.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
30 | |
26 | |
21 | |
20 |
User | Count |
---|---|
63 | |
48 | |
24 | |
24 | |
19 |