Forum Discussion

faheem_Latif_BI's avatar
1 year ago
Solved

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 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 

     

1 Reply

  • 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