Extract Power BI metadata from Power BI Service

HI powerbiexpert22,

Yes, you can extract Power BI Service metadata, such as the number of datasets, reports, and dataflows in each workspace, by using the Power BI REST APIs or Admin (Scanner) APIs.

If you need information only for workspaces you have access to, the standard REST APIs can help:

GET /groups/{groupId}/datasets – lists datasets in a workspace

GET /groups/{groupId}/reports – lists reports in a workspace

You can loop through all your workspace IDs to count the total artifacts.

For tenant-wide metadata or automation, Microsoft offers the Admin Scanner API (PostWorkspaceInfo), which gathers detailed metadata like reports, datasets, dataflows, refresh schedules, RLS, and lineage across all workspaces.

This requires Fabric Admin permissions or a service principal with metadata scanning enabled in the Power BI admin portal.

After starting the scan (POST /admin/workspaces/getInfo), you can access results with GET /admin/workspaces/scanResult?scanId={id}.

Datasets - Get Datasets In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Reports - Get Reports - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Admin - WorkspaceInfo PostWorkspaceInfo - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Thank you.