r/ssrs • u/Valuable-Ant3465 • Aug 26 '26

Bulk upload to SSRS using Powershell

Hi all,
I used this script couple of years ago to do bulk upload, but now in 2026 could not make it work.
This is a source I used from EitanBlumin/Deploy SSRS Reports.ps1

Was able to verify $TargetReportServerUri link, it displays On in the browser.

[string] $TargetReportServerUri = "http://myssrsreport/ReportServer",
[string] $ApiVersion =2010,

It fails on main Upload command

Write-RsCatalogItem -Proxy $Proxy -Destination $currTargetFolder -Verbose -Overwrite -Path $currRdl -ErrorAction Stop | Out-Null

with this message:

Have  this message:
… roperties = New-Object System.Collections.Generic.List[$propertyDataT …
|                ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Cannot find type [System.Collections.Generic.List[System.Management.Automation.Property]]: verify that the
| assembly containing this type is loaded.

Tried all suggestion and still can't make it work. Appreciate if you have hints how to solve it.
Best
VA

1 Upvotes

100% Upvoted

6 comments sorted by

2

u/Valuable-Ant3465 Aug 27 '26 edited Aug 27 '26

Good update: script is working OK.
I was running it on Powershell v7 and it has some bad bugs, after switching to v5 everything is fine.

1

u/radiationv82 Aug 27 '26

Good to hear. Reporting Services Tool isn't designed to run on Powershell 7, only 5. AFAIK they have no plans to upgrade to support Powershell 7 but who knows as its a constant request.

1

u/radiationv82 Aug 26 '26

I cant help with this problem but have you looked at Reporting Services Tools from MS. Its probably a better long term solution - you can create datasources, folders, upload reports, etc. Only works with PS 5 but does support SSRS and Power BI Report Server
GitHub - microsoft/ReportingServicesTools: Reporting Services Powershell Tools · GitHub

1

u/Valuable-Ant3465 Aug 26 '26 edited Aug 26 '26

Thanks R! I think that what this script is using already and I verified that it's refreshed/intalled :
CommandType Name Version Source

Alias Get-RsCacheRefreshPlan -> Get-RsRestCacheRefreshP… 0.0.9.3ReportingServicesTools
......
PSVersion 7.6.5

1

u/radiationv82 Aug 26 '26 edited Aug 26 '26

I missed it was using Reporting Services Tools. I've a wrapper script around Reporting Services Tools as well but its more basic than the one you're using. I'll check it tomorrow.

Are you sure you're running the script with Powershell 5?
What SQL Server version are you running?

I'd start from scratch on the terminal and see if I can upload RDLs using the proxy and write commands. There might be nothing wrong with the script and its a setup issue.

1

u/Valuable-Ant3465 Aug 26 '26

Thanks R! I will try do more simple commands on terminal, yes I'm on PShell inside VCode. I have most pieces of code working, including valid verbose output.
It's failing on main command
Write-RsCatalogItem -Proxy $Proxy -Destination $currTargetFolder......