Occasionally we are asked how to download the .pbix for our reports for editing in Power BI Desktop, or how to move custom reports from one to another Power BI tenant. This blog will show you how to do both. However, the downloaded .pbix will not include the dataset. By design, it is not possible to download the dataset of a Power BI template app. To edit the .pbix in Power BI Desktop you must connect to a PowerStacks dataset in the Power BI service.
PowerShell
#################
function Assert-ModuleExists([string]$ModuleName) {
$module = Get-Module $ModuleName -ListAvailable -ErrorAction SilentlyContinue
if (!$module) {
Write-Host "Installing module $ModuleName ..."
Install-Module -Name $ModuleName -Force -Scope Allusers
Write-Host "Module installed"
}
elseif ($module.Version -ne '1.0.0' -and $module.Version -le '1.0.410') {
Write-Host "Updating module $ModuleName ..."
Update-Module -Name $ModuleName -Force -ErrorAction Stop
Write-Host "Module updated"
}
}
## Install-Module -Name MicrosoftPowerBIMgmt
Assert-ModuleExists -ModuleName "MicrosoftPowerBIMgmt"
## Connect to the PowerBi Service
Connect-PowerBIServiceAccount
####################
#Find the Workspaces
$AllWorkspaces = Get-PowerBIWorkspace ### FILTER TO SHOW ONLY BI FOR INTUNE Workspaces REMOVE TO SHOW OTHERS ##### | Where-Object {$_.Name -like "*Intune*"}
## Select the source workspace
$SourceWorkspace = $AllWorkspaces | Out-GridView -Title 'Choose a source workspace' -PassThru
Write-Host "Source Workspace '" $SourceWorkspace.Name "'"
##Find the source dataset
$SourceDataset = Get-PowerBIDataset -WorkspaceId $SourceWorkspace.Id
if($SourceDataset -ne $null){
## Select the destination workspace
$DestinationWorkspace = $AllWorkspaces | Where-Object {$_.Id -ne $SourceWorkspace.Id} | Out-GridView -Title 'Choose a destination workspace' -PassThru
Write-Host "Destination Workspace '" $DestinationWorkspace.Name "'"
##Find the destination dataset
$DestinationDataset = Get-PowerBIDataset -WorkspaceId $DestinationWorkspace.Id
if($DestinationDataset -ne $null){
###################################
##Destination Workspace
###################################
## Find the custom reports in the source workspace
$SourceReports = Get-PowerBIReport -WorkspaceId $SourceWorkspace.Id
## Copy the source reports to the destination workspace using the destination dataset
$SourceReportsUniqueID = @()
$SourceReportIDMapping = @{}
Foreach ($Report in $SourceReports){
if(-Not($Report.Id -in $SourceReportsUniqueID)){
$SourceReportsUniqueID += @($Report.Id)
if($Report.Name -eq $powerbiapp){
$dt = Get-Date -Format "yyyy-MM-dd"
$NewReportName = $Report.Name + " " + $dt
}else{
$NewReportName = $Report.Name
}
Write-host "About to copy Report '" $Report.Name "' to '" $NewReportName "' from Workspace '" $SourceWorkspace.Name "' to Workspace '" $DestinationWorkspace.Name "'"
if($Report.DatasetId -eq $SourceDataset.Id){
$NewReport = Copy-PowerBIReport -Name $NewReportName -Id $Report.Id -WorkspaceId $SourceWorkspace.Id -TargetWorkspaceId $DestinationWorkspace.Id -TargetDatasetId $DestinationDataset.Id
}else{
$NewReport = Copy-PowerBIReport -Name $NewReportName -Id $Report.Id -WorkspaceId $SourceWorkspace.Id -TargetWorkspaceId $DestinationWorkspace.Id -TargetDatasetId $Report.DatasetId
}
if ($NewReport){
$SourceReportIDMapping[$Report.Id] = [guid]$NewReport.Id
}
}
}
## Find the custom dashboards in the source workspace
$SourceDashboards = Get-PowerBIDashboard -WorkspaceId $SourceWorkspace.Id
## Copy the source dashboards to the destination workspace using the destination reports
$SourceDashboardsUniqueID = @()
Foreach ($Dashboard in $SourceDashboards) {
if(-Not($Dashboard.Id -in $SourceDashboardsUniqueID)){
$SourceDashboardsUniqueID += @($Dashboard.Id)
Write-Host "About to copy Dashboard '" $Dashboard.Name "' from Workspace '" $SourceWorkspace.Name "' to Workspace '" $DestinationWorkspace.Name "'"
$NewDashboard = New-PowerBIDashboard -Name $Dashboard.Name -WorkspaceId $DestinationWorkspace.Id
$SourceDashboardTiles = Get-PowerBITile -WorkspaceId $SourceWorkspace.Id -DashboardId $Dashboard.Id
$TilesUniqueID = @()
Foreach ($Tile in $SourceDashboardTiles) {
if(-Not($Tile.Id -in $TilesUniqueID)){
$TilesUniqueID += @($Tile.Id)
Write-Host "About to copy Tile '" $Tile.Id "' to Dashboard '" $NewDashboard.Name "in Workspace '" $DestinationWorkspace.Name "'"
if($SourceReportIDMapping[[guid]$Tile.ReportId]){
$NewTile = Copy-PowerBITile -WorkspaceId $SourceWorkspace.Id -DashboardId $Dashboard.Id -TileId $Tile.Id -TargetDashboardId $NewDashboard.Id -TargetWorkspaceId $DestinationWorkspace.Id -TargetReportId $SourceReportIDMapping[[guid]$Tile.ReportId] ##-TargetDatasetId $tile_target_dataset_id
}else{
$NewTile = Copy-PowerBITile -WorkspaceId $SourceWorkspace.Id -DashboardId $Dashboard.Id -TileId $Tile.Id -TargetDashboardId $NewDashboard.Id -TargetWorkspaceId $DestinationWorkspace.Id -TargetReportId $Tile.ReportId ##-TargetDatasetId $tile_target_dataset_id
}
}
}
}
}
###################################
##Other Workspaces
###################################
if($DestinationDataset.Id){
## Find the custom reports in the other workspaces
$OtherWorkspaces = $AllWorkspaces | Where-Object {$_.Id -ne $SourceWorkspace.Id} | Where-Object {$_.Id -ne $DestinationWorkspace.Id}
$OtherWorkspacesUniqueID = @()
## Copy the custom reports to the same workspace using the destination dataset
Foreach ($OtherWorkspace in $OtherWorkspaces){
if(-Not($OtherWorkspace.Id -in $OtherWorkspacesUniqueID)){
$OtherWorkspacesUniqueID += @($OtherWorkspace.Id)
$OtherReports = Get-PowerBIReport -WorkspaceId $OtherWorkspace.Id | Where-Object {$_.DatasetId -eq $SourceDataset.Id}
$OtherReportsUniqueID = @()
$OtherReportIDMapping = @{}
Foreach ($OtherReport in $OtherReports){
if(-Not($OtherReport.Id -in $OtherReportsUniqueID)){
$OtherReportsUniqueID += @($OtherReport.Id)
$dt = Get-Date -Format "yyyy-MM-dd"
$BackupReportName = $OtherReport.Name + " " + $dt
Write-host "About to copy Report '" $OtherReport.Name "' to '" $BackupReportName "' in Workspace '" $OtherWorkspace.Name "'"
$NewOtherReport = Copy-PowerBIReport -Name $BackupReportName -Id $OtherReport.Id -WorkspaceId $OtherWorkspace.Id -TargetWorkspaceId $OtherWorkspace.Id -TargetDatasetId $DestinationDataset.Id
$OtherReportIDMapping[$OtherReport.Id] = [guid]$NewOtherReport.Id
}
}
## Find the custom dashboards in the source workspace
$OtherDashboards = Get-PowerBIDashboard -WorkspaceId $OtherWorkspace.Id
## Copy the custom dashboards to the same workspace using the copy reports
$OtherDashboardsUniqueID = @()
Foreach ($OtherDashboard in $OtherDashboards) {
if(-Not($OtherDashboard.Id -in $OtherDashboardsUniqueID)){
$OtherDashboardsUniqueID += @($OtherDashboard.Id)
$OtherDashboardTiles = Get-PowerBITile -WorkspaceId $OtherWorkspace.Id -DashboardId $OtherDashboard.Id
$CopyOtherDashboard = 0
$OtherTilesUniqueID = @()
Foreach ($OtherTile in $OtherDashboardTiles) {
if(-Not($OtherTile.Id -in $OtherTilesUniqueID)){
$OtherTilesUniqueID += @($OtherTile.Id)
if($OtherTile.DatasetId -eq $SourceDataset.Id){
#This tile contains the Source Dataset
$CopyOtherDashboard = 1
break
}
}
}
if($CopyOtherDashboard){
$dt = Get-Date -Format "yyyy-MM-dd"
$BackupDashboard = $OtherDashboard.Name + " " + $dt
Write-Host "About to copy Dashboard '" $OtherDashboard.Name "' to '" $BackupDashboard "' in Workspace '" $OtherWorkspace.Name "'"
$NewOtherDashboard = New-PowerBIDashboard -Name $BackupDashboard -WorkspaceId $OtherWorkspace.Id
$OtherTilesUniqueID = @()
Foreach ($OtherTile in $OtherDashboardTiles) {
if(-Not($OtherTile.Id -in $OtherTilesUniqueID)){
$OtherTilesUniqueID += @($OtherTile.Id)
Write-Host "About to copy Tile '" $OtherTile.Id "' to Dashboard '" $NewOtherDashboard.Name "' in Workspace '" $OtherWorkspace.Name "'"
if($OtherReportIDMapping[[guid]$OtherTile.ReportId]){
$NewOtherTile = Copy-PowerBITile -WorkspaceId $OtherWorkspace.Id -DashboardId $OtherDashboard.Id -TileId $OtherTile.Id -TargetDashboardId $NewOtherDashboard.Id -TargetReportId $OtherReportIDMapping[[guid]$OtherTile.ReportId]
}else{
$NewOtherTile = Copy-PowerBITile -WorkspaceId $OtherWorkspace.Id -DashboardId $OtherDashboard.Id -TileId $OtherTile.Id -TargetDashboardId $NewOtherDashboard.Id -TargetReportId $OtherTile.ReportId
}
}
}
}
}
}
}
}
}
}
}Create a Power BI Workspace
- In the Power BI service select Workspaces.
- Select New workspace.
This workspace will be used as a temporary location to store the reports that you want to download. It can be removed once you have downloaded the .pbix.
Name the Workspace
- Enter a Name for the workspace.
- Select Apply.
Create a New Dataset
- In your new workspace select New.
- Select Dataset.
Define the Dataset
- Select Paste or manually enter data.
Create the Dataset
- On the Get data pane provide a Name for the dataset. I recommend using the same name as the dataset name in the workspace of the template app.
- Select Create a dataset only.
Ignore the Warning
- On the Enter data prompt select Create.
Copy the Script
- Open PowerShell ISE or your favorite code editor as Administrator.
- Copy the PowerShell script from the top of this page and paste it into the code editor.
- Run the script.
- When prompted to sign in use the same credentials that you use for Power BI.
Select Source Workspace
- At the Choose a source workspace prompt select the workspace containing the Power BI template app.
- Select OK.
Select Destination Workspace
- At the Choose a destination workspace select the workspace that you created following the steps above.
- Select OK.
Check for Errors
- Confirm no errors are in the script output.
Go to The Workspace
- In the Power BI service select Workspaces.
- Select the workspace that you created following the steps above.
Confirm Reports are Present
- In your workspace you should have a copy of each report from the workspace of the template app. If you do not see them refresh the browser page.
Download a .pbix
- Open a set of reports for the workspace.
- Select File.
- Select Download this file.
Download Report and Data
- At the What do you want to download prompt select A copy of your report and data (.pbix).
- Select Download.
Open the .pbix
- Open the downloaded .pbix in Power BI Desktop.
- Switch to Model view.
- Select the Vertical Ellipsis on the dataset.
- Select Delete from this model.
Install the Template App in New Tenant
Before proceeding ensure that you have installed the Power BI template app in the new tenant.
If you simply wanted to modify the reports in Power BI desktop and upload them back to the template app in the tenant from which you downloaded them, you may do that also.
Add Template App Dataset
- This step can get tricky. If you are moving the reports to a new tenant, you might need to sign out of Power BI desktop and sign in to Power BI desktop with credentials from the new tenant.
- In Power BI Desktop select Get data.
- Select Power BI datasets.
Connect to Online Dataset
- Select the dataset in the workspace that you'd like to upload the reports. This could be the same as the original source or in a new tenant.
- Select Connect.
Optionally Edit Reports
- In Power BI Desktop switch to Report view.
- You will notice that you have access to the online dataset and the report pages in the report. If you'd like to modify or creates pages do so now.
Publish Report
- In Power BI Desktop select File.
- Select Publish.
Publish to Power BI
- Select Publish to Power BI.
Save Report
- If prompted, select Save.
Select Destination
- Select the Power BI template app workspace where you would like to publish the report. This should be the same workspace that you connected to in the "Connect to Online Dataset" step above.
- Select "Select".
Success!
You should see a Success dialog box.
Confirm Publish
In the Power BI service, you should now see your published report. If not, refresh the page in your browser.
