List of all reports from Power BI Service

[viswaaa]

Hi All,

I am Power BI Admin.

I need to build a report to show all reports from all the workspaces  dynamically.

If any new report added in any workspace that should come to my report automatically

How to do this please help

[Kedar_Pande]

@viswaaa 

Use Admin REST API – Get Reports in Group with a Power BI Service Principal or Admin account

[Shahid12523]

Register Azure AD App → Get API access.
Use Power BI REST API → Pull workspaces + reports.
Load into Power BI via Power Query or Dataflow
Schedule refresh → Auto-updates when new reports are added.
Build your report → Show report name, workspace, owner, etc.

[Nasif_Azam · Accepted solution]

Hey @viswaaa ,

Fully dynamic options as a Power BI Admin:

1) Admin Monitoring workspace: You are Fabric/Power BI Admin, open Admin monitoring and use the Feature usage & adoption semantic model. It already contains an Inventory of items (reports, datasets, workspaces). You can build your own report on top of that semantic model and publish it. New reports/workspaces show up automatically as the model refreshes. (Microsoft Learn)

Steps: Admin Portal → Admin monitoring → open Feature usage & adoption → Build a new report from its semantic model. (Microsoft Learn)

2) Scanner Admin APIs: Use the Metadata Scanning / WorkspaceInfo (Scan) Admin APIs to extract a tenant-wide catalog, then land it in a Lakehouse/Dataflow and build a Power BI model on it. This gives you rich metadata (labels, lineage, endorsements, etc.) and refresh can be scheduled so new reports automatically appear. Requires enabling Admin API settings for detailed metadata and (optionally) service principal access. (Microsoft Learn)

Key endpoints:

• Admin WorkspaceInfo Scan: kicks off and reads scan results (all items). (Microsoft Learn)

• Admin GetReportsAsAdmin: direct list of reports across the organization (quick inventory). (Microsoft Learn)

Note: If you want plug-and-play dynamic tenant inventory then start with Admin monitoring → Feature usage & adoption and build your custom report on its semantic model. If you need deeper metadata and full control, implement the Scanner Admin APIs. For a quick win, PowerShell does the trick. (Microsoft Learn)

Best Regards,
Nasif Azam

[Tahreem24]

@viswaaa ,

1. Power BI Admin rights (you already have this).

2. Admin API access enabled in the Power BI tenant settings.

3. A method to call the REST API regularly (via Power BI Dataflow, Power Automate, or external tools like Azure Functions or PowerShell).

4. Power BI Dataset or report that ingests and visualizes this data.