List of workspaces and users

[hoonybro90]

Hello,

I was wondering if there is a was to get a list of all the workspaces and users assigned to those workspaces.

I been reading about the admin portal for powerbi but i dont think it supports something like that. I did see that it has a usage metrics dashboard, but the detail is only up to the dashboard level and not the workspace level.

We are trying to keep a list of who has access to what and this kind of feature would be helpful.

Thank you in advance

[v-yuezhe-msft]

@hoonybro90,

Power BI app workspaces are actually office 365 groups. You can consider to list these Office 365 Groups and their members using Powershell, for more details, please review the following blog.

http://www.morgantechspace.com/2016/06/list-office-365-group-members-using-powershell.html

Regards,
Lydia

[hoonybro90]

@v-yuezhe-msft Would love to give this a go, but I dont have admin right to the office 365 groups.

Will give it a go an write a feedback when we get a chance!

[Greg_Deckler]

There are Audit Log items for Sharing a Dashboard, etc. that may be useful.

[hoonybro90]

Audit logs do sound interesting, but in our case, it isnt exactly what we are looking for.

[KarlCullimore]

The power shell is a good solution to the workspace members but has anyone had any joy trying to list the members of a power BI App ?

[GilbertQ]

Hi @hoonybro90

The only way that I know of currently is if you have got the Audit Logs Enabled to see who has accessed the Workspace, as they would then be members of the Workspace.

I am hopefuly that someone else might have a more elegant solution.

[opticshrew]

I'm in agreement with @GilbertQ on this one.

The Audit logs only show who has accessed and modified items within a workspace. These include everything from create/delete through to viewing a dashboard.

Thanks,

J