all workspace data

[faheem_Latif_BI]

HI ALL,

i need a compelete data of following

1-All workspaces names

2-all reportorts related to workspaces 

3-owner of samentic models

4-Who acces those reports in last one year

Regards 

[nilendraFabric · Accepted solution]

Hello @faheem_Latif_BI 

here I am sharing powershell and rest api both for each of your usecase

you will need admin access to run some of these 

List of All Workspaces

Connect-PowerBIServiceAccount
$Workspaces = Get-PowerBIWorkspace -Scope Organization -All
$Workspaces | Select Name

GET https://api.powerbi.com/v1.0/myorg/admin/groups

All Reports Related to Workspaces

foreach ($Workspace in $Workspaces) {
$Reports = Get-PowerBIReport -WorkspaceId $Workspace.Id
$Reports | Select Name, WorkspaceId
}

GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports

Owner of Semantic Models

foreach ($Workspace in $Workspaces) {
$Datasets = Get-PowerBIDataset -WorkspaceId $Workspace.Id
$Datasets | Select Name, Owner
}

GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets

Users Who Accessed Reports in the Last Year

Get-PowerBIActivityEvent -StartDateTime "2024-02-06T00:00:00" -EndDateTime "2025-02-06T23:59:59"
Filter the logs for report access events.

Please accept the answer if this is helpful