![\"Power](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/05\/Technical-blog-30-05-25.png\")
<\/p>\n<\/p>\n
Power BI has become an essential tool for business intelligence and reporting.<\/p>\n
However, managing Power BI reports across different environments or workspaces can be time-consuming and error-prone.<\/p>\n
PowerShell offers an efficient and reliable method to automate the export and import of Power BI reports.<\/p>\n
In this blog post, we\u2019ll walk through how to use PowerShell to export Power BI reports from one workspace and import them into another. We\u2019ll also cover how to update dataset parameters and refresh datasets after the import.<\/p>\n
To interact with Power BI, you need to authenticate. There are multiple ways to authenticate:<\/p>\n
Connect-PowerBIServiceAccount<\/p>\n
$username = \u201c\u201d\r\n$password = \u201c\u201d | ConvertTo-SecureString -asPlainText -Force\r\n\r\n$credential = New-Object System.Management.Automation.PSCredential($username, $password)\r\n\r\nConnect-PowerBIServiceAccount -Credential $credential<\/pre>\n
$clientId = \"your-client-id\"\r\n\r\n$clientSecret = \"your-client-secret\" | ConvertTo-SecureString -AsPlainText -Force\r\n\r\n$tenantId = \"your-tenant-id\"\r\n\r\n$credential = New-Object System.Management.Automation.PSCredential($clientId, $clientSecret)\r\n\r\nConnect-PowerBIServiceAccount -ServicePrincipal -TenantId $tenantId -Credential $credential<\/pre>\nStep 2: Export Power BI Reports<\/strong><\/h3>\n
Once authenticated, you can export reports from a specific workspace. Here\u2019s how:<\/p>\n
1. Retrieve the Workspace<\/strong>:<\/p>\n
$workspaceId = “your-workspace-id”<\/p>\n
$workspace = Get-PowerBIWorkspace -Id $workspaceId<\/p>\n
2. Export Reports<\/strong>:<\/p>\n
Specify the export path and export the reports.\r\n\r\n$exportPath = \"C:\\Temp\\PowerBIExports\"\r\n\r\nif (!(Test-Path -Path $exportPath)) {\r\n\r\nNew-Item -ItemType Directory -Path $exportPath\r\n\r\n}\r\n\r\n\u00a0\r\n\r\n$reports = Get-PowerBIReport -WorkspaceId $workspace.Id\r\n\r\nforeach ($report in $reports) {\r\n\r\n$filePath = Join-Path -Path $exportPath -ChildPath \"$($report.Name).pbix\"\r\n\r\nExport-PowerBIReport -WorkspaceId $workspace.Id -ReportId $report.Id -OutFile $filePath\r\n\r\n}<\/pre>\nStep 3: Import Power BI Reports<\/strong><\/p>\n
After exporting the reports, you can import them into a new workspace.<\/p>\n
1. Create a New Workspace<\/strong>:<\/p>\n
$newWorkspace = New-PowerBIWorkspace -Name “New Workspace”<\/p>\n
2. Import Reports<\/strong>: Import the reports from the export path.<\/p>\n
$reportsToImport = Get-ChildItem -Path $exportPath -Filter \"*.pbix\"\r\n\r\nforeach ($reportFile in $reportsToImport) {\r\n\r\n$filePath = Join-Path -Path $exportPath -ChildPath $reportFile.Name\r\n\r\nNew-PowerBIReport -Path $filePath -Workspace $newWorkspace\r\n\r\n}<\/pre>\nStep 4: Update Dataset Parameters and Refresh<\/strong><\/p>\n
After importing the reports, you may need to update the dataset parameters and refresh the datasets.<\/p>\n
1. Update Dataset Parameters<\/strong>:<\/p>\n
$datasetId = \"your-dataset-id\"\r\n\r\n$body = '{\r\n\r\n\"updateDetails\": [\r\n\r\n{\r\n\r\n\"name\": \"EnvironmentURL\",\r\n\r\n\"newValue\": \"your-new-value\"\r\n\r\n}\r\n\r\n]\r\n\r\n}'\r\n\r\nInvoke-PowerBIRestMethod -Url \"\/datasets\/$datasetId\/Default.UpdateParameters\" -Method Post -Body $body<\/pre>\n2. Refresh Dataset<\/strong>:<\/p>\n
Invoke-PowerBIRestMethod -Method Post -Url “groups\/$($newWorkspace.Id)\/datasets\/$datasetId\/refreshes”<\/p>\n
Step 5: Update Data Source Credentials<\/strong> You must update the credentials if the imported reports rely on data sources.<\/p>\n
1. Retrieve Data Sources<\/strong>:<\/p>\n
$datasources = Get-PowerBIDatasource -WorkspaceId $newWorkspace.Id -DatasetId $datasetId<\/p>\n
2. Update Credentials<\/strong>:<\/p>\n
foreach ($datasource in $datasources) {\r\n\r\n$body = @{\r\n\r\n\"credentialDetails\" = @{\r\n\r\n\"credentialType\" = \"OAuth2\"\r\n\r\n\"encryptedConnection\" = \"Encrypted\"\r\n\r\n\"useCallerAADIdentity\" = $true\r\n\r\n}\r\n\r\n}\r\n\r\n$jsonBody = $body | ConvertTo-Json -Depth 5\r\n\r\nInvoke-PowerBIRestMethod -Url \"https:\/\/api.powerbi.com\/v1.0\/myorg\/gateways\/$($datasource.GatewayId)\/datasources\/$($datasource.DatasourceId)\" -Method PATCH -Body $jsonBody\r\n\r\n}<\/pre>\nConclusion<\/strong><\/h2>\n
By automating the export and import of Power BI reports using PowerShell, you can save time and reduce the risk of errors. This approach is particularly useful when managing multiple workspaces or environments. Whether you\u2019re migrating reports or setting up new environments, PowerShell provides a flexible and powerful way to streamline the process.<\/p>\n","protected":false},"excerpt":{"rendered":"
Power BI has become an essential tool for business intelligence and reporting. However, managing Power BI reports across different environments or workspaces can be time-consuming and error-prone. PowerShell offers an efficient and reliable method to automate the export and import of Power BI reports. In this blog post, we\u2019ll walk through how to use PowerShell\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":15,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[45,2361],"tags":[1339,3159],"class_list":["post-41358","post","type-post","status-publish","format-standard","hentry","category-power-bi","category-technical","tag-power-bi","tag-powershell"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/41358","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=41358"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/41358\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=41358"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=41358"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=41358"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}