cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hoonybro90 Frequent Visitor
Frequent Visitor

List of workspaces and users

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

 

7 REPLIES 7
Super User
Super User

Re: List of workspaces and users

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.

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
opticshrew Member
Member

Re: List of workspaces and users

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

Super User
Super User

Re: List of workspaces and users

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Moderator v-yuezhe-msft
Moderator

Re: List of workspaces and users

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hoonybro90 Frequent Visitor
Frequent Visitor

Re: List of workspaces and users

@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!

hoonybro90 Frequent Visitor
Frequent Visitor

Re: List of workspaces and users

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

Highlighted

Re: List of workspaces and users

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 ?