{"id":43802,"date":"2026-04-07T14:58:14","date_gmt":"2026-04-07T12:58:14","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=43802"},"modified":"2026-04-07T14:58:16","modified_gmt":"2026-04-07T12:58:16","slug":"scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/","title":{"rendered":"Scaling SSRS Migrations: Multi-Threaded Automation for PBIRS 2025"},"content":{"rendered":"\n

Modernizing a reporting platform is a pivotal milestone for any BI infrastructure. Whether it\u2019s a standard upgrade or a forced transition to Power BI Report Server (PBIRS)<\/a><\/strong> following the decommissioning of SSRS in SQL Server 2025, the operation is critical. For the purposes of our lab, we will use an SSRS 2017 source, but the logic remains universal: regardless of the original version, the goal is to ensure the continuity of your decision-making services without sacrificing your mental health in the process.<\/p>\n\n\n\n

As my colleague Amine Haloui explained in a recent blog post<\/a>, several strategies exist for migrating an instance. The “Lift and Shift” method (restoring the ReportServer<\/code> database onto a new instance) is often the most attractive on paper. However, the reality on the ground can be more temperamental.<\/p>\n\n\n\n

In some production environments, the target PBIRS instance already exists, hosts its own content, or follows specific configurations that prohibit simply overwriting its underlying ReportServer<\/code> database. Therefore, we are proceeding here on the premise of a selective and granular migration: we must inject the SSRS catalog into an active PBIRS environment without burning everything to the ground in the process.<\/p>\n\n\n\n

When faced with inventories exceeding hundreds or even thousands of reports (RDL), folders, and datasources, a manual approach via the web interface is not an option and automation becomes a necessity.<\/p>\n\n\n\n

This article analyzes a systematic approach based on the ReportingServicesTools<\/code> PowerShell module. The objective is to provide a robust methodology to extract your catalog and redeploy it intelligently, while managing the necessary reconfigurations along the way.<\/p>\n\n\n\n

Phase 1: Smart Dumping \u2013 Building the Local Staging Area<\/h2>\n\n\n\n

To migrate cleanly, objects must first be isolated. The idea is not to blindly vacuum everything, but to target the critical folders of your SSRS instance and transform them into flat files (.rdl and .rds) within a local staging area. If your SSRS instance contains specific object types, the scripts can easily be adapted to include them as well.<\/p>\n\n\n\n

This is where the power of the SOAP Proxy<\/a><\/strong> comes into play. Rather than multiplying slow HTTP calls, we use the native service interface to list and extract our components:<\/p>\n\n\n

\n$sourceUrl  = "http:\/\/your-ssrs-server\/ReportServer"\n$exportRoot = "H:\\Migration_Dump"\n\n$proxySource = New-RsWebServiceProxy -ReportServerUri $sourceUrl\n<\/pre><\/div>\n\n\n
In a production environment, SSRS folders are often a messy mix of reports, data sources, images, and sometimes obsolete semantic models. To maintain total control over what we export, we isolate the filtering logic.<\/p>\n\n\n\n
This Get-AllItemsByType<\/code> function allows us to retrieve only what truly matters to us, based on the TypeName<\/strong> and file extension<\/strong> returned by the API.<\/p>\n\n\n
\nfunction Get-AllItemsByType {\n    param(\n        [string]$CurrentPath,\n        $Proxy,\n        [string]$TypeName \n    )\n    try {\n        return $Proxy.ListChildren($CurrentPath, $true) | Where-Object { $_.TypeName -eq $TypeName }\n    } catch {\n        Write-Host "  [!] Error on $CurrentPath : $($_.Exception.Message)" -ForegroundColor Red\n        return $null\n    }\n}\n<\/pre><\/div>\n\n\n
This mapping between the file type and its extension must be defined upfront in a dictionary:<\/p>\n\n\n
\n$extensionMap = @{\n    "Report" = ".rdl"\n    "DataSource" = ".rds"\n}\n<\/pre><\/div>\n\n\n
A crucial point in extracting SSRS objects is preserving their context. To ensure a seamless import into PBIRS 2025, we must recreate the exact folder hierarchy of the source server locally.<\/p>\n\n\n\n
The trick lies in transforming the SSRS path (formatted as \/Folder\/SubFolder\/Report<\/code>) into a valid Windows path, while simultaneously handling the extension mapping (.rdl<\/code> for reports, .rds<\/code> for DataSources).<\/p>\n\n\n
\nfunction Export-SsrsItems {\n    param(\n        [string]$RootPath,\n        $Proxy,\n        [string]$TypeName,\n        [string]$ExportRoot\n    )\n\n    $items = Get-AllItemsByType -CurrentPath $RootPath -Proxy $Proxy -TypeName $TypeName\n\n    foreach ($item in $items) {\n        $relativeItemPath = $item.Path.TrimStart('\/').Replace("\/", "\\")\n        $localFilePath    = Join-Path $ExportRoot $relativeItemPath\n        $localDirectory   = Split-Path -Path $localFilePath -Parent\n\n        if (-not (Test-Path $localDirectory)) {\n            New-Item -ItemType Directory -Path $localDirectory -Force | Out-Null\n        }\n\n        Out-RsCatalogItem -Path $item.Path -Destination $localDirectory -Proxy $Proxy\n    }\n}\n<\/pre><\/div>\n\n\n
By doing this, your H:\\Migration_Dump<\/code> becomes the exact mirror of your SSRS portal. This structural rigor is what will allow us, in the next step, to remap our data sources without having to hunt down which report belongs to which department.<\/p>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n<\/div>\n<\/div>\n\n\n\n
Finally, we define the folders we wish to export along with the document types they contain (since a migration is often the perfect time for a bit of spring cleaning):<\/p>\n\n\n
\n$exportTasks = @(\n    @{ Path = "\/Migration_Source_2"; Types = @("Report") },\n    @{ Path = "\/Data Sources";  Types = @("DataSource") }\n)\n\nWrite-Host "--- Selective Export Started ---" -ForegroundColor Cyan\n\nforeach ($task in $exportTasks) {\n    foreach ($typeName in $task.Types) {\n        $ext = $extensionMap[$typeName]\n        Export-SsrsItems `\n            -RootPath   $task.Path `\n            -Proxy      $proxySource `\n            -TypeName   $typeName `\n            -Extension  $ext `\n            -ExportRoot $exportRoot\n    }\n}\n<\/pre><\/div>\n\n
\n
\"\"<\/figure>\n<\/div>\n\n\n
Phase 2: Data Source Patching \u2013 Mass XML Transformation<\/h2>\n\n\n\n
Once the extraction is complete, you have a local mirror of your source instance, but the data sources still point to the legacy infrastructure.<\/p>\n\n\n\n
Instead of manually fixing each connection after the import (the best way to miss half of them), we will apply an automated transformation directly to our local XML files. This allows us to update connection strings in bulk before a single report even hits the target server.<\/p>\n\n\n\n
The idea is simple: use PowerShell to inject the new SQL instance wherever necessary, ensuring a functional deployment from the very first second:<\/p>\n\n\n
\n$allDataSources = Get-ChildItem -Path $exportRoot -Filter "*.rds" -Recurse\n\nWrite-Host "[>] Datasources updated in : $exportRoot" -ForegroundColor Yellow\n\nforeach ($dsFile in $allDataSources) {\n    [xml]$xmlContent = Get-Content $dsFile.FullName\n \n    $node = $xmlContent.SelectSingleNode("\/\/ConnectString")\n    \n    if ($null -ne $node) {\n        $oldValue = $node."#text" \n        if ($null -eq $oldValue) { $oldValue = $node.InnerText }\n\n        $newValue = $oldValue -replace "OLD_REPORTING_INSTANCE", "NEW_REPORTING_INSTANCE"\n        \n        if ($oldValue -ne $newValue) {\n            $node.InnerText = $newValue\n            $xmlContent.Save($dsFile.FullName)\n            Write-Host "  [v] ConnectString updated in : $($dsFile.Name)" -ForegroundColor Green\n        }\n    } else {\n        Write-Host "  [!] ConnectString not found in file $($dsFile.Name)" -ForegroundColor Red\n    }\n}\n<\/pre><\/div>\n\n\n
Moreover, since we are interacting directly with the file\u2019s XML structure, this logic isn’t limited to connection strings: you can apply the same principle to automate changes for any XML property, from timeouts to provider names.<\/p>\n\n\n\n
Phase 3: Mass Deployment \u2013 Rebuilding the Reporting Portal<\/h2>\n\n\n\n
At this stage, the operation is purely mechanical. We once again leverage the ReportingServicesTools<\/strong> module to recreate the folder structure and upload the .rds<\/code> and .rdl<\/code> files. By following this specific order, PBIRS will automatically restore the links between your reports and their newly patched data sources.<\/p>\n\n\n\n
It is worth noting that the script allows for importing into a specific root folder (defined by the $destroot<\/code> variable). This is particularly useful if you want to isolate the migrated assets into a dedicated directory, such as SSRS_Folder<\/code> to keep them distinct from the existing hierarchy. Furthermore, this script is designed with safety in mind: it cannot overwrite or delete anything. If a report with the same name already exists in the same location, the -Overwrite:$false<\/code> argument prevents replacement, ensuring that the import process never destroys existing content.<\/p>\n\n\n\n
Here is the final block to complete your migration:<\/p>\n\n\n
\n$destUrl   = "http:\/\/your-pbirs-server\/ReportServer" \n$localDump = "H:\\Migration_Dump"\n$destRoot  = "\/" #Start import in the root folder\n$proxyDest = New-RsWebServiceProxy -ReportServerUri $destUrl\n\n$extensionMap = @{\n    "Report"     = ".rdl"\n    "DataSource" = ".rds"\n}\n\nfunction Ensure-RsFolderBruteForce {\n    param($fullFolderPath, $Proxy)\n    $parts = $fullFolderPath.Split('\/') | Where-Object { $_ -ne '' }\n    $currentPath = ''\n    \n    foreach ($part in $parts) {\n        $parent = if ($currentPath -eq '') { "\/" } else { $currentPath }\n        $target = if ($currentPath -eq '') { "\/$part" } else { "$currentPath\/$part" }\n        \n        try {\n            $Proxy.CreateFolder($part, $parent, $null) | Out-Null\n            Write-Host "  [DIR] Created : $target" -ForegroundColor Cyan\n        } catch {\n            if ($_.Exception.Message -match "AlreadyExists") {\n                # Folder already exists but we continue\n            } else {\n                Write-Host "  [!] Error for folder $target : $($_.Exception.Message)" -ForegroundColor Red\n            }\n        }\n        $currentPath = $target\n    }\n}\n\nfunction Import-SsrsItem {\n    param(\n        [System.IO.FileInfo]$File,\n        [string]$LocalDump,\n        [string]$DestRoot,\n        $Proxy\n    )\n\n    $relativeDir       = $File.DirectoryName.Replace($LocalDump, '').Replace("\\", "\/")\n    $targetFolderPath  = ($DestRoot + $relativeDir).Replace("\/\/", "\/")\n    $fullItemPath      = ($targetFolderPath + "\/" + $File.BaseName).Replace("\/\/", "\/")\n\n    Ensure-RsFolderBruteForce -fullFolderPath $targetFolderPath -Proxy $Proxy\n\n    try {\n        Write-RsCatalogItem -Path $File.FullName -Destination $targetFolderPath -Proxy $Proxy -Overwrite:$false\n        Write-Host "  [DONE] Imported: $fullItemPath" -ForegroundColor Green\n    }\n    catch {\n        if ($_.Exception.Message -match "already exists") {\n            Write-Host "  [SKIP] Already created : $fullItemPath" -ForegroundColor Gray\n        } else {\n            Write-Host "  [FAIL] Error $fullItemPath : $($_.Exception.Message)" -ForegroundColor Red\n        }\n    }\n}\n\n$importOrder = @("DataSource", "Report")\n\nforeach ($typeName in $importOrder) {\n    $extension = $extensionMap[$typeName]\n    Write-Host "`n[PASS] Import of object with type : $typeName ($extension)" -ForegroundColor Magenta\n    \n    $filesToImport = Get-ChildItem -Path $localDump -Filter "*$extension" -Recurse\n\n    if ($filesToImport.Count -eq 0) {\n        Write-Host "  [i] No file with $extension found." -ForegroundColor Gray\n        continue\n    }\n\n    foreach ($file in $filesToImport) {\n        Import-SsrsItem -File $file -LocalDump $localDump -DestRoot $destRoot -Proxy $proxyDest\n    }\n}\n\nWrite-Host "`nImport done!" -ForegroundColor Green\n<\/pre><\/div>\n\n\n
Importing via SOAP is more resource-intensive than extraction, as the server must validate every piece of metadata and physically recreate the path for each report. On large volumes, this stage can become a bottleneck (averaging ~1 second per report).<\/p>\n\n\n\n
To overcome this, we can parallelize the import by folder, creating multiple background jobs running on separate threads. Here is the general skeleton to implement this multi-threaded approach:<\/p>\n\n\n
\n$maxJobs = 5 \n\nforeach ($file in $filesToImport) {\n    while ((Get-Job -State Running).Count -ge $maxJobs) {\n        Start-Sleep -Milliseconds 500\n    }\n\n    Start-Job -Name "Import_$($file.Name)" -ScriptBlock {\n        param($f, $url, $targetPath)\n\n        $Proxy = New-RsWebServiceProxy -ReportServerUri $url\n        \n        try {\n            Write-RsCatalogItem -Path $f.FullName -Destination $targetPath -Proxy $Proxy -Overwrite:$false\n            return "SUCCESS: $($f.Name)"\n        } catch {\n            return "ERROR: $($f.Name) -> $($_.Exception.Message)"\n        }\n    } -ArgumentList $file, $destUrl, $targetFolderPath\n}\n<\/pre><\/div>\n\n
\n
\"\"<\/figure>\n<\/div>\n\n\n
Note :<\/strong> The -Parallel<\/a><\/code> parameter is a feature of the ForEach-Object<\/code> cmdlet introduced in PowerShell 7 to enable native multi-threading. While it allows for processing multiple objects simultaneously, it is not reliably supported by the ReportingServicesTools<\/code> library as the underlying API is not thread-safe. To ensure stability and avoid session collisions, it is recommended to use the Start-Job<\/code> method instead, as it provides better process isolation for each task.<\/p>\n\n\n\n
Key Takeaways for a Seamless Cutover<\/h2>\n\n\n\n
Migrating to Power BI Report Server shouldn’t be a manual challenge. By adopting this PowerShell-driven ETL approach<\/strong>, you replace the uncertainty of manual intervention with industrial-grade rigor.<\/p>\n\n\n\n
The primary advantage lies in consistency: regardless of the report volume or folder complexity, the script guarantees an identical and predictable result every single time. By isolating extraction, XML transformation, and ordered importation, you maintain total control over your data integrity.<\/p>\n\n\n\n
Ultimately, automation is about securing your delivery and freeing up time for what truly matters: leveraging your data on your brand-new PBIRS 2025 platform.<\/p>\n\n\n\n
Happy migrating!<\/p>\n","protected":false},"excerpt":{"rendered":"
Modernizing a reporting platform is a pivotal milestone for any BI infrastructure. Whether it\u2019s a standard upgrade or a forced transition to Power BI Report Server (PBIRS) following the decommissioning of SSRS in SQL Server 2025, the operation is critical. For the purposes of our lab, we will use an SSRS 2017 source, but the […]<\/p>\n","protected":false},"author":157,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[294,99],"tags":[3974,272,1346,596],"type_dbi":[2874],"class_list":["post-43802","post","type-post","status-publish","format-standard","hentry","category-business-intelligence","category-sql-server","tag-pbirs","tag-powershell","tag-sqlserver","tag-ssrs","type-sql-server"],"acf":[],"yoast_head":"\nScaling SSRS Migrations: Multi-Threaded Automation for PBIRS 2025 - dbi Blog<\/title>\n<meta name=\"description\" content=\"Gemini a ditMigrate SSRS to PBIRS 2025: a PowerShell ETL to automate extraction, XML patching, and parallelized deployment.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Scaling SSRS Migrations: Multi-Threaded Automation for PBIRS 2025\" \/>\n<meta property=\"og:description\" content=\"Gemini a ditMigrate SSRS to PBIRS 2025: a PowerShell ETL to automate extraction, XML patching, and parallelized deployment.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2026-04-07T12:58:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-07T12:58:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-7.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1145\" \/>\n\t<meta property=\"og:image:height\" content=\"318\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Louis Tochon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Louis Tochon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/\"},\"author\":{\"name\":\"Louis Tochon\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/e4195b0cb120295b3407a502c23e75b6\"},\"headline\":\"Scaling SSRS Migrations: Multi-Threaded Automation for PBIRS 2025\",\"datePublished\":\"2026-04-07T12:58:14+00:00\",\"dateModified\":\"2026-04-07T12:58:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/\"},\"wordCount\":1070,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-7-1024x284.png\",\"keywords\":[\"PBIRS\",\"PowerShell\",\"SQLServer\",\"SSRS\"],\"articleSection\":[\"Business Intelligence\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/\",\"name\":\"Scaling SSRS Migrations: Multi-Threaded Automation for PBIRS 2025 - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-7-1024x284.png\",\"datePublished\":\"2026-04-07T12:58:14+00:00\",\"dateModified\":\"2026-04-07T12:58:16+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/e4195b0cb120295b3407a502c23e75b6\"},\"description\":\"Gemini a ditMigrate SSRS to PBIRS 2025: a PowerShell ETL to automate extraction, XML patching, and parallelized deployment.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-7.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-7.png\",\"width\":1145,\"height\":318},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Scaling SSRS Migrations: Multi-Threaded Automation for PBIRS 2025\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/e4195b0cb120295b3407a502c23e75b6\",\"name\":\"Louis Tochon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/ce0ee48c64e763e6c4076e21c80729d15bc4493288aeb8695125c69082100e10?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ce0ee48c64e763e6c4076e21c80729d15bc4493288aeb8695125c69082100e10?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ce0ee48c64e763e6c4076e21c80729d15bc4493288aeb8695125c69082100e10?s=96&d=mm&r=g\",\"caption\":\"Louis Tochon\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/louistochon\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Scaling SSRS Migrations: Multi-Threaded Automation for PBIRS 2025 - dbi Blog","description":"Gemini a ditMigrate SSRS to PBIRS 2025: a PowerShell ETL to automate extraction, XML patching, and parallelized deployment.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/","og_locale":"en_US","og_type":"article","og_title":"Scaling SSRS Migrations: Multi-Threaded Automation for PBIRS 2025","og_description":"Gemini a ditMigrate SSRS to PBIRS 2025: a PowerShell ETL to automate extraction, XML patching, and parallelized deployment.","og_url":"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/","og_site_name":"dbi Blog","article_published_time":"2026-04-07T12:58:14+00:00","article_modified_time":"2026-04-07T12:58:16+00:00","og_image":[{"width":1145,"height":318,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-7.png","type":"image\/png"}],"author":"Louis Tochon","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Louis Tochon","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/"},"author":{"name":"Louis Tochon","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/e4195b0cb120295b3407a502c23e75b6"},"headline":"Scaling SSRS Migrations: Multi-Threaded Automation for PBIRS 2025","datePublished":"2026-04-07T12:58:14+00:00","dateModified":"2026-04-07T12:58:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/"},"wordCount":1070,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-7-1024x284.png","keywords":["PBIRS","PowerShell","SQLServer","SSRS"],"articleSection":["Business Intelligence","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/","url":"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/","name":"Scaling SSRS Migrations: Multi-Threaded Automation for PBIRS 2025 - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-7-1024x284.png","datePublished":"2026-04-07T12:58:14+00:00","dateModified":"2026-04-07T12:58:16+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/e4195b0cb120295b3407a502c23e75b6"},"description":"Gemini a ditMigrate SSRS to PBIRS 2025: a PowerShell ETL to automate extraction, XML patching, and parallelized deployment.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-7.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-7.png","width":1145,"height":318},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/scaling-ssrs-migrations-multi-threaded-automation-for-pbirs-2025\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Scaling SSRS Migrations: Multi-Threaded Automation for PBIRS 2025"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/e4195b0cb120295b3407a502c23e75b6","name":"Louis Tochon","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ce0ee48c64e763e6c4076e21c80729d15bc4493288aeb8695125c69082100e10?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ce0ee48c64e763e6c4076e21c80729d15bc4493288aeb8695125c69082100e10?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ce0ee48c64e763e6c4076e21c80729d15bc4493288aeb8695125c69082100e10?s=96&d=mm&r=g","caption":"Louis Tochon"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/louistochon\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/43802","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/157"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=43802"}],"version-history":[{"count":41,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/43802\/revisions"}],"predecessor-version":[{"id":43852,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/43802\/revisions\/43852"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=43802"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=43802"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=43802"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=43802"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}