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

[karo]

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

[v-nuoc-msft]

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.

[karo]

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]

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

[karo]

@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)?