Forum Discussion
Workspace Access Request: View pending requests API or query? (no reply email)
Is there anyway to view a list of the users who have requested access and are in the "pending" list for access to a report in a workspace? (EDIT: programatically, in a way I can have code parse the pending list and send out emails to them or put their emails into a workflow to process their requests, etc)
The email MSFT PBI sends lists the user's display name but NOT their actual UPN or email address. It also does not provide a reply email, so we can't just automatically reply to the email to contact the user requesting access.
We need a way to search for users with outstanding access requests and contact them (likely send them an email with instructions and a link to our access request processing page).
Hi sasdfasdfsad
- Power BI REST API: Use GET /groups/{workspaceId}/users to list users in a workspace. Pending requests aren’t directly exposed, but you can manage user access and statuses.
- PowerShell: Use Get-PowerBIWorkspaceUser to list workspace users and filter by "Pending" status. You can automate email notifications using Send-MailMessage.
- Power Automate: Automate workflows by logging requests in a system (e.g., SharePoint) and sending emails via Power Automate.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS
5 Replies
Hi! sasdfasdfsad
You can access the workspace as an admin and review the "Access" tab in the workspace settings.
Hi sasdfasdfsad
Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi sasdfasdfsad
- Power BI REST API: Use GET /groups/{workspaceId}/users to list users in a workspace. Pending requests aren’t directly exposed, but you can manage user access and statuses.
- PowerShell: Use Get-PowerBIWorkspaceUser to list workspace users and filter by "Pending" status. You can automate email notifications using Send-MailMessage.
- Power Automate: Automate workflows by logging requests in a system (e.g., SharePoint) and sending emails via Power Automate.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKSThank you, I'm going to try PowerShell.
Does PowerAutomate have a way to see the requests? I didn't realize it had a PBI interface hook?Sadly I have to have Power BI global Admin to use the PowerShell module. Thank you though, this WAS the right answer to solve my problem.
MicrosoftPowerBIMgmt.Workspaces Module | Microsoft Learn
