Extract Users name + roles from workspace

Question

Greeting members ,&nbsp;&nbsp;i have a workspace where i have over 300 members (95% are viewers )&nbsp;&nbsp;is there a way that i can extract the whole list in a file (ex : Excel ) ? (Email + Role)&nbsp;also is there a way i can dublicate the list in another workspace ?&nbsp;&nbsp;my account is Power BI Pro .&nbsp;&nbsp;Thanks in advance all&nbsp;&nbsp;

lbendlin · Answer

classic (v1) or modern (v2) workspace?

amitchandak · Answer

Ramyzo , you should be able to get user list in usages metrics
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-usage-metrics
&nbsp;
Other
https://www.mssqltips.com/sqlservertip/6487/power-bi-workspace-permissions-and-roles/
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces

ramyzo · Answer

Modern workspace&nbsp;

lbendlin · Answer

Use the Workspaceusers audit log extracts for that.

swise001 · Answer

Ramyzo&nbsp;&nbsp;You'll likely need to be a Power BI Admin to do this using the Power BI cmdlets.&nbsp;&nbsp;Here's a script from some past work to do more or less the same export:&nbsp;https://stackoverflow.com/questions/54702764/how-to-extract-all-powerbi-users-and-workspace-access-using-the-powerbi-api-or-a&nbsp;&nbsp;

Forum Discussion

Extract Users name + roles from workspace

6 Replies

Related content

1000 Workspace User Limit

Can't add workspace user

Extract Data from sharepoint

How to extract a list of reports and users with access across all workspaces?

Workspaces capacities & user access