Mapping of all the workspace and list of users and groups

[Anonymous]

Hey Everyone,

Is there any way to prepare a metadata sheet / master list / mapping sheet of all the workspaces and list of users and usergroups who have access to those workspaces.

Is there any api which can help in this scenario ?

Many thanks for any relevant input.

[v-luwang-msft · Accepted solution]

Hi @Anonymous ,

Try to use PowerShell:

Connect-PowerBIServiceAccount

$Workspaces = Get-PowerBIWorkspace -Scope Organization -All 

$Workspaces | 
    ForEach-Object {
        $Workspace = $_.name
        foreach ($User in $_.Users) {
            [PSCustomObject]@{
                Workspace = $Workspace
                User      = $User.UserPrincipalName
            }
        }
    } | Export-CSV "D:\\PowerBIGroupMembers.csv" -NoTypeInformation -Encoding UTF8

If the script above doesn't display users, try this:

Connect-PowerBIServiceAccount
$Workspaces = Get-PowerBIWorkspace -Scope Organization -All 
$Workspaces | 
    ForEach-Object {
        $Workspace = $_.name
        foreach ($User in $_.Users) {
            [PSCustomObject]@{
                Workspace = $Workspace
                User      = $User.Identifier 
            }
        }
    } | Export-CSV "D:\\PowerBIGroupMembers.csv" -NoTypeInformation -Encoding UTF8

refer:

https://community.powerbi.com/t5/Developer/Powershell-Get-workspaces-for-specified-group-of-users/m-p/2188566 

Best Regards,

Lucien

[lbendlin]

That is all part of the tenant inventory API. You need to be tenant admin to see these.