How to export list of PBI Workspace users and emails

[Marian]

I need to maintain the list of users with an access to the PBI space.  I could not find any export button from the Workspace "Manage Access"  option. There is only one button to Add a new user but no export of users.  Since we have hundreds of users in space, looking at the first top 20 users and scrol and manually copy one by one is really not an  efficient user management.   Or at least not for me...   This list solution is ridiculos  and I cannot even believe such a big company as Microsoft manages anly few users in any space themselves, or they like manual management of hundreds of users? 

How can I export the full list in one go? 

Qlik Sense as an example has tha bulk export and bulk import of users functionality built in ...

[ibarrau]

Hi, you can use the Power Bi Rest API. You can go ahead and get workspaces. Capture the ID and then loop one by one with the following request:

https://learn.microsoft.com/en-us/rest/api/power-bi/groups/get-group-users

If you are a Power Bi Admin you can also do it as admin

https://learn.microsoft.com/en-us/rest/api/power-bi/admin/groups-get-group-users-as-admin

The difference is that the regular request will only get and let you take workspace you can see with your user. The admin request will work for all created workspaces at the tenant.

If you are not a fan of coding or scripting, be sure to get help or user powershell cmdlets or a python library like SimplePBI instead of developing the whole thing.

I hope that helps,

[Marian]

Thanks for suggestion. Unfortunatelly none of the suggested  works in our setup: 

Access to api.powerbi.com was denied

You don't have authorization to view this page.

I am admin in the space and I can manage access ....

It is pitty there is no embeded solution to ease the bulk management...(export,import) . Most of the time IT  admin is not the reporting developer at the same... time

[ibarrau]

I'm sorry, I would say you have a talk with IT to explain the importance of your situation. You just need them to Register an App in and give you the details.

Otherwise you won't be able to do it. 

Also, if you can register an app in azure active directory, then that would be enough. You can set your permissions registering the app.

I hope you can get a solution with IT department.

Regards,