PowerShell script to list Power BI workspaces and export to Excel

pbi_listPowerBIWorkspaces.ps1

Connect-PowerBIServiceAccount

#Get-PowerBIWorkspace | Get-Member

#$ws = Get-PowerBIWorkspace -Scope Organization -Filter "tolower(name) eq 'testworkspace'"
#$ws = Get-PowerBIWorkspace -Scope Organization | Where {($_.IsOnDedicatedCapacity -eq $true) -and ($_.State -eq "Active") -and ($_.Type -ne "PersonalGroup")}
$ws = Get-PowerBIWorkspace -Scope Organization -All
$workspace =
foreach ($w in $ws) {
    [PSCustomObject] @{
        Name  = $w.Name
        Type  = $w.Type
        State = $w.State
        "Dedicated Capacity" = $w.IsOnDedicatedCapacity
    }
}

$workspace | Export-Excel -Path C:\Temp\pbi_workspaces.xls