Forum Discussion
all workspace data
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
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 WorkspacesConnect-PowerBIServiceAccount
$Workspaces = Get-PowerBIWorkspace -Scope Organization -All
$Workspaces | Select NameGET 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 YearGet-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
1 Reply
- nilendraFabricSuper User
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 WorkspacesConnect-PowerBIServiceAccount
$Workspaces = Get-PowerBIWorkspace -Scope Organization -All
$Workspaces | Select NameGET 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 YearGet-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