BUG - Power BI API - Admin - Groups GetGroupsAsAdmin

[DAG360]

I currently have an Azure Data Factory Pipeline that extracts all Power BI Groups from our tenancy. Just recently as of 1/13/2022.

the endpoint used: Admin - Groups GetGroupsAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Docs

I have tested this using the bearer token in postman and getting the following error same as on the MS test page.

Based on MS docs: this is the required parameter to be passed under admin/groups and pass a parameter integer vaule for the top n and fails:

GET https://api.powerbi.com/v1.0/myorg/admin/groups?$top={$top}

I have also tested with URL encoding as there may have been a recent change that replaces the "$" for the encoding equal to "%24" and still cannot get a 200 response.

Posting this here as I believe there an issue with this endpoint.  

[v-yingjl]

Have submited this issue internal to confirm(ICM: 284234045), would update here as soon as possible if there is any progress about it.

Best Regards,
Community Support Team _ Yingjie Li

[DAG360]

@v-yingjl - Thank you for looking into this. I am hopeful this issue get's resolved soon as a production break fix.

All the best.

Dan.

[v-yingjl]

Update from PG team:

Fix is being deployed for the issue, most likely to be deployed within 4-5 days.

In the meantime you can try below workarounds:

• Most likely error will be gone on making top fetch param to high value say 5000. But if the tenant contains more than 5000 workspaces then workaround won't work.

            e.g.  https://api.powerbi.com/v1.0/myorg/admin/groups?%24top=5000

• Another option is to add worktype filter param to the api

Best Regards,
Community Support Team _ Yingjie Li

[DerekLedbetter]

Update 8/28/2024

I'm trying to use the API 
Admin - Groups GetGroupsAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Learn

I've tried both ways.
https://api.powerbi.com/v1.0/myorg/admin/groups?$top={$top}
I've also tried "https://api.powerbi.com/v1.0/myorg/admin/groups?%24top=5000"
Neither one works.



It produces an error
Invoke-PowerRestMethod : The term 'Invoke-PowerRestMethod' is not recognized as the name of a cmdlet, function, script file, or
operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
At C:\Users\31096\OneDrive - Cone Health\Documents\PowerShellScript\PowerBIRESTApiGetGroups.ps1:26 char:13
+ $response = Invoke-PowerRestMethod -Url $uri -Method Get -headers $he ...
+ ~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : ObjectNotFound: (Invoke-PowerRestMethod:String) [], CommandNotFoundException
+ FullyQualifiedErrorId : CommandNotFoundException

When will this issue be resolved?