cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kat12345
Helper III
Helper III

orphaned workspaces with API

Dear all,

 

Happy new year 2022!

 

I am writing because i would like to use the API  in order to get the list of orphaned workspaces (spaces without admin or members)

https://docs.microsoft.com/en-us/rest/api/power-bi/admin/groups-get-groups-as-admin#get-orphaned-wor... 

 

I am surprised by the sample response because: it shows "State = Active" => If it is orphaned, the state should be "Orphaned"???

 

{ "value": [ { "id": "d5caa808-8c91-400a-911d-06af08dbcc31", "isReadOnly": false, "isOnDedicatedCapacity": false, "name": "Orphaned Group", "description": "Sample orphan group", "type": "Workspace", "state": "Active", "users": [] } ] }

 

thank you, 

2 ACCEPTED SOLUTIONS

Thank you very much Evelyn!!

If i understand well what you said,

your test tells that the workspace is  still active, but orphaned because there is no administrator in this workspace?

View solution in original post

Eyelyn9
Community Support
Community Support

Hi @Kat12345 ,

 

I have found the following descriptions for the states:

  • Active – A regular workspace that is available and accessible
  • Deleted – A deleted workspace that still exists in the Power BI service
  • Orphaned – A workspace without a user account with administrator permissions
  • Removing – A deleted workspace marked for permanent removal

 

Based on it, I think orphaned workspace is still available and accessible, so it's reasonable that the Api returns "Active" state.

 

 

Refer to:

Power BI admin portal - Power BI | Microsoft Docs

Workspace Management in the Admin Portal | Microsoft Power BI Blog | Microsoft Power BI

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
Kat12345
Helper III
Helper III

hi

 

I would like to get the list of orphaned workspaces on premium capacity

  • Orphaned – A workspace without a user account with administrator permissions

tx for your reply

Run two inventory extracts, one for workspaces and one for WorkspacesUsers. Compare the results in a Power BI or SQL data model.

Eyelyn9
Community Support
Community Support

Hi @Kat12345 ,

 

I have found the following descriptions for the states:

  • Active – A regular workspace that is available and accessible
  • Deleted – A deleted workspace that still exists in the Power BI service
  • Orphaned – A workspace without a user account with administrator permissions
  • Removing – A deleted workspace marked for permanent removal

 

Based on it, I think orphaned workspace is still available and accessible, so it's reasonable that the Api returns "Active" state.

 

 

Refer to:

Power BI admin portal - Power BI | Microsoft Docs

Workspace Management in the Admin Portal | Microsoft Power BI Blog | Microsoft Power BI

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Eyelyn9
Community Support
Community Support

Hi @Kat12345 ,

 

I have a test, it acted as the official document said, the state returned by Api is Active while the actual state is Orphaned:

 

Eyelyn9_1-1641880632720.png

So it‘s probably by design. I think it's reasonable since the workspace just doesn't have the Admin role.

 

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you very much Evelyn!!

If i understand well what you said,

your test tells that the workspace is  still active, but orphaned because there is no administrator in this workspace?

Kat12345
Helper III
Helper III

 

1/ no this is not a personal workspace

2/ yes i can see that in the sample response it is not on premium capacity.

3/ I would like to retrieve the liste of ORPHANED WORKSPACE.... and i am suprised because in the sample response (Microsoft document see above the link) it shows "State = Active" => If it is orphaned, the state should not be "Orphaned"??? 

 

thank you

lbendlin
Super User
Super User

That workspace is not on Premium capacity - is it someone's personal workspace?

What are you ultimately trying to achieve?  Orphaned workspaces don't really have much of an impact.

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!