Forum Discussion
Power BI Workspace Server Request Approvals
I have a few dashboards in PowerBI workspace server. I was wondering is there a way somehow to see all pending requests for all the dashboards at once rather than going into each report and checking it under manager permission?
Hi,
Short answer: no, the Power BI service doesn't give you one screen with all pending access requests across reports. Requests are tied to each individual item, so "Manage permissions" is per report and there's no aggregated pending-requests view in the portal.
The realistic fix is to stop the per-report requests from happening in the first place:
Publish the reports as a Power BI App and give people access to the app audience instead of to each report. Then there's one access point to manage rather than one per report.
Better still, grant access through a security group (or M365 group) rather than to individuals. People get added to the group, the group has access, and you're not approving one-off requests at all. When someone new needs in, you add them to the group in one place.
If you specifically want to pull the requests programmatically, the admin REST API is the only route, but honestly that's more work than just consolidating access so the requests stop landing individually.
So there's no dashboard for it by design. Routing access through an app or a group is what most people switch to once the per-report approvals get annoying.
If this answers your question, please mark it as the solution so others with the same question find it faster.
Paco
Power BI reports for large viewer groups
5 Replies
Hi homboy27
I dont believe there is currently any capability for this as of nowHi homboy27,
The documentation explains that pending access requests for individual reports and dashboards are reviewed on each item's Manage permissions page, where workspace Admins and Members can approve or decline them. For Power BI Apps, pending requests are handled through the app's Manage permissions > Pending access page. It also says that workspaces do not include a built-in Request access workflow. So if your reports and dashboards are shared individually, you'll need to check pending requests from the Manage permissions page for each report or dashboard.
Power BI implementation planning: Report consumer security planning - Power BI | Microsoft Learn
Publish an app in Power BI - Power BI | Microsoft Learn
Request or Grant Access to Shared Dashboards or Reports - Power BI | Microsoft Learn
Thank you.
Hi homboy27 ,
Wanted to let you know that currently there is NO option avaialble to provide a centralized view of all pending access requests across every report/dashboard in a workspace.Currently, pending requests can only be viewed by opening the individual item's Manage permissions page (Workspace > Report/Dashboard > Manage permissions > Pending requests). Workspace Admins and Members can approve or deny requests from there.
However, I would recomend an alternative
Email notifications: Configure the report or app contact so access requests are emailed to a shared mailbox or distribution list. This is often the easiest way to avoid missing requests.
Identify/Create the User email / Microsoft 365 group / email-enabled security group.Workspace Steps: Workspace > Settings > Contact list > add the user / group > Save or Workspace > Settings > General > Contact list > Notifications(Workspace contacts) > add the user / group > Save.
For an importanat individual report or dashboard steps: Semantic Model Settings > Request access > add the user / group > Save.
Using this you will get a access request notifications, approve your convienent and update the app(if using).
References:- Set contact information for reports and dashboards in the Power BI service - Power BI | Microsoft Learn
- Publish an app in Power BI - Power BI | Microsoft Learn
Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.Hi homboy27,
Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.
Thank you.
Hi,
Short answer: no, the Power BI service doesn't give you one screen with all pending access requests across reports. Requests are tied to each individual item, so "Manage permissions" is per report and there's no aggregated pending-requests view in the portal.
The realistic fix is to stop the per-report requests from happening in the first place:
Publish the reports as a Power BI App and give people access to the app audience instead of to each report. Then there's one access point to manage rather than one per report.
Better still, grant access through a security group (or M365 group) rather than to individuals. People get added to the group, the group has access, and you're not approving one-off requests at all. When someone new needs in, you add them to the group in one place.
If you specifically want to pull the requests programmatically, the admin REST API is the only route, but honestly that's more work than just consolidating access so the requests stop landing individually.
So there's no dashboard for it by design. Routing access through an app or a group is what most people switch to once the per-report approvals get annoying.
If this answers your question, please mark it as the solution so others with the same question find it faster.
Paco
Power BI reports for large viewer groups
