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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
karo
Advocate V
Advocate V

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
Super User
Super User

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.