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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
karo
Post Patron
Post Patron

How to get the list of all Workspaces in the Tenant unassigned to Power BI Domains

Hi,

 

I am wonder if there is a smart way to get the list of all Power BI Workspaces in my Tenant what are unassigned to Power BI Domain/s?

 

Regards,

Karo

4 REPLIES 4
v-nuoc-msft
Community Support
Community Support

Hi @karo 

 

To get a list of all Power BI workspaces in a tenant that are not assigned to the Power BI domain, you can try using the Power BI PowerShell cmdlet.

 

Power BI Cmdlets reference | Microsoft Learn

 

The reference code is as follows:

 

# Login to Power BI Service
Connect-PowerBIServiceAccount

# Get the list of all workspaces
$workspaces = Get-PowerBIWorkspace -Scope Organization -All

# Filter out workspaces that are unassigned to any Power BI Domain
$unassignedWorkspaces = $workspaces | Where-Object { $_.Domain -eq $null }

# Display the list of unassigned workspaces
$unassignedWorkspaces

 

Before this code can be executed, your PowerShell session needs to be logged into the Power BI service and your account needs to have the appropriate permissions to access workspace information.

 

In addition, this code assumes that the Get-PowerBIWorkspace command will run in your PowerShell session, which usually requires the PowerBI PowerShell module to be installed.

 

Regards,

Nono Chen

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

Hi @v-nuoc-msft , Thank you for reply. I have tried your code and it is not fully worked. I get the list of workspaces, however on the list are also included Workspaces where the Domain is assigned (I have checked several examples from the top and in Power BI Service the Domain (ex. Sales) is assigned, moreover the Domain has been assigned long time ago therefore it is not latecy issue)

SaiTejaTalasila
Solution Sage
Solution Sage

Hi @karo ,

 

You can extract power bi audit logs or activity logs.And that data will be having all the required data.

 

Thanks,

Sai Teja

@SaiTejaTalasilaCan you please refer to exact Power BI APIs or Cmdlets what we can use to get info about workplace assignment to Domains (Domains - Microsoft Fabric | Microsoft Learn)?

Helpful resources

Announcements
PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.