exporting List of Workspaces and all users to excel

[Anonymous]

Hello,

is there a way to export list of All work spaces and memebrs under those workspaces to excel

Currently there is an option in Power BI Admin Portal to export only Workspace ID name and descritpion 

I am also tyring to get all Member owners Id under worksapce.

Thanks

[ahmadov_10]

Hello Experts, i need to export the list of users (names, mails) for a specific Power BI Workspace using Power Shell (or other solution) to csv file , i give you my informations that i used in the script (that i replaced them with the correct informations , my email, password , workspace_id ) :

workspaceId : "my_workspace_id"

userName : 'my_user'

password : 'my_password'

csvFilePath : "C:\Users\my_file.csv"

i used many commands methods in powershell and not works , please if you have any solutions in powershell or others ?

[AliceW]

Accidentally found an answer just now.

Go in the workspace.

Click on the 'Access' icon (like you you when you add someone).

Then, anywhere in the page, right-click, Save As, then Save as type: Text Files.

You'll get a beautiful text file with the users and, the chery on the cake, their rights (Viewer, Contributor etc.).

Of course, this file also includes some other data, but you can just skip to the good parts.

[Icey · 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

Reference: PowerBI Query – Trying to list workspaces and users.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.