Forum Discussion
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)
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,
Hi Anonymous ,
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.
7 Replies
Hi Anonymous ,
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.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.
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
Hi Anonymous ,
I have a test, it acted as the official document said, the state returned by Api is Active while the actual state is Orphaned:
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.Run two inventory extracts, one for workspaces and one for WorkspacesUsers. Compare the results in a Power BI or SQL data model.
