how to export user list of user and Permission details

[vengadesh_p]

Hi All,

 I want to export workspace  user list & their permission 

1) I tried table capture Extenstion --> its not working in powerbi 
2) Tried power shell --> its not working 

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

3) tried following query in consol.. BUT I only get back the number of rows that is visible on the browser screen

$('.row').each(function() { console.log (

$(this).find('div.user-name').text(),",",$(this).find('span.col-emailAddress').text(),",",$(this).find('span.col-permissions').text())})

 
Please help me to export userlist from powerbi service

[v-cgao-msft · Accepted solution]

Hi @vengadesh_p ,

Please try this Rest Api.

GET https://api.powerbi.com/v1.0/myorg/admin/groups/{groupId}/users

You must have administrator privileges (such as Office 365 Global Administrator or Power BI Service Administrator) or be authenticated using the service principal. Delegated permissions are supported.

Sample response:

Admin - Groups GetGroupUsersAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data