Power BI Admin-Access to all workspaces

[RajCZ]

as a Power BI administrator, I need to able to access all Power BI workspaces and all contents inside Power BI in the tenant.

I know it is possible to gain access workspace by workspace by using "Admin portal" --> "Workspaces" --> click on desired workspace "..." and grant myself access. 

But this sounds more like a manual and repeative work and doesn't make it easy for administration, because

1. I do not know when a new workspaces was created and it is manual work to add admins to each and every workspace

2. It also confuses workspace members that now there is also another person allowed to access their workspace (when they check the Access menu)

Is there any other way to gain access to workspaces(at least all public workspaces)

I tried powershell script, that loops through all workspaces and makes me admin of workspaces.

but since I don't even have minimum permission on workspace , so no workspace comes in loop.

Thank you

[RajCZ]

Thanks, this way I can get workspace ids for other workspaces, eventhough I have to give permission one by one, is that right or I am missing something.

Thanks

[RajCZ]

Hi Above script needs workspace id, since I don't have access to workspace, I can't get workspace id and again it's manual, one workspace at a time.

[Brunner_BI]

First do this

https://learn.microsoft.com/en-us/rest/api/power-bi/admin/groups-get-groups-as-admin#code-try-0

[Brunner_BI]

What do you want to do when you have access to 1.000 workspaces?

You give yourself access through another API call

https://learn.microsoft.com/en-us/rest/api/power-bi/admin/groups-add-user-as-admin

There is a limit of 200 requests per hour for one tenant.