Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
So we have lots of workspaces that have content but we would like to move the content to one workspace for easy-to-find reports/datasets/apps/etc. With the new workspaces, is there a way to merge, migrate, or simply transport information to another workspace? The idea is to be able to delete workspaces after their contents have been moved.
Solved! Go to Solution.
Hi @Anonymous ,
A workspace can only have one app.
Please try copy reports from other workspaces or duplicate workspaces using the Power BI REST APIs
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes, very easy to do with PowerShell.
Below is a snippet of powershell I use to create the workspace automatically.
# STEP 1.1: Connect to to the PowerService
Connect-PowerBIServiceAccount
$StartTime = $(get-date)
#------------------------------------------------------------------
# STEP 2.1: Create Workspace 1
#------------------------------------------------------------------
$Workspace_Name1 = "My Workspace"
$target_workspace1 = New-PowerBIWorkspace -Name $Workspace_Name1
if (!$target_workspace1 -or $target_workspace1.isReadOnly -eq "True") {
Write-Error "Invalid choice: you must have edit access to the workspace."
break
}
# Update Wrkspace Description
Set-PowerBIWorkspace -Scope Organization -Id $target_workspace1.id -Description "My Description."
# STEP 2.2: Grant Mark access to Workspace
Add-PowerBIWorkspaceUser -Scope Individual -Id $target_workspace1.Id -UserEmailAddress myUser@mycorp.onmicrosoft.com -AccessRight Admin
# STEP 2.3: Upload File.
New-PowerBIReport -Path 'C:\temp\PowerBI\My Dashboard.pbix' -Name 'The Dashboard' -Workspace ( Get-PowerBIWorkspace -Name $Workspace_Name1 )
$elapsedTime = $(get-date) - $StartTime
$totalTime = "{0:HH:mm:ss}" -f ([datetime]$elapsedTime.Ticks)
Write-Host $totalTime
Hi @Anonymous ,
my be this link will help you: https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-copy-reports
Best,
Kathrin
If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!
Thanks for the response @KBO, I'll look into it.
To add to the original question...what about apps? Is there a way to move apps between workspaces?
Hi @Anonymous ,
A workspace can only have one app.
Please try copy reports from other workspaces or duplicate workspaces using the Power BI REST APIs
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
54 | |
39 | |
33 | |
31 | |
25 |