Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

0

BUG - Power BI API - Admin - Groups GetGroupsAsAdmin

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.

 

DAG360_0-1642606542842.png

 

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.  

 

 

Status: Delivered

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

Comments
v-yingjl
Community Support
Status changed to: Accepted

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
New Member

@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
Community Support
Status changed to: Delivered

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