Workspace Access Request: View pending requests API or query? (no reply email)

[sasdfasdfsad]

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).

[Poojara_D12 · Accepted solution]

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 

[sasdfasdfsad]

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

[sasdfasdfsad]

Thank 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?

[Anonymous]

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.

[AnkitKukreja]

Hi! @sasdfasdfsad 

You can access the workspace as an admin and review the "Access" tab in the workspace settings.