Forum Discussion
Workspace Access Request: View pending requests API or query? (no reply email)
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
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
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?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
