cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hoonybro90
Advocate IV
Advocate IV

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
v-yuezhe-msft
Microsoft
Microsoft

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

@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
Super User IV
Super User IV

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


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




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

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
Super User II
Super User II

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 Super User!







Power BI Blog

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors