Powershell script to do automated deployments for SSRS 2014, error while setting a shared dataset


trying write powershell script automated deployments ssrs 2014.  my problem linking report shared dataset.  i keep getting error:  [error] cannot convert argument "itemreferences", value: "system.object[]", for 
[error] "setitemreferences" type "ssrs.reportingservice2010.itemreference[]": 
[error] "cannot convert "ssrs.reportingservice2010.itemreference" value of type 
[error] "ssrs.reportingservice2010.itemreference" type 
[error] "ssrs.reportingservice2010.itemreference"."
[error] @ c:\users\bshaw20\documents\ssrs\powershell deploy\ssrs deploy\ssrs 
[error] deploy\prototypev4.ps1:224 char:46
[error] +         $rs.setitemreferences($reportpath, @($mydataset))
[error] +                                              ~~~~~~~~~~
[error]     + categoryinfo          : notspecified: (:) [], methodexception
[error]     + fullyqualifiederrorid : methodargumentconversioninvalidcastargument

here script:

function linkshareddatasets {
  # list of reports , link them shared datasets

$reportserveruri = "http://reportingdev.energytransfer.net/reportserver/reportservice2010.asmx?wsdl"

$rs = new-webserviceproxy -uri $reportserveruri -usedefaultcredential -namespace ssrs.reportingservice2010
$rpts = $rs.listchildren($targetfolderrdl, $false)

  $newdatasetname = "/interstate apps/commercial/set/setsum"
  $myds = "setsum"

  $rpts | foreach-object {
    $reportpath = $_.path
    write-host "report: " $reportpath
    $datasets = $rs.getitemreferences($reportpath, "dataset")
    $datasets | foreach-object {
      if ($_.name -eq $myds) {
        $mydataset = new-object -typename ssrs.reportingservice2010.itemreference
        $mydataset.name = $myds
        $mydataset.reference = $newdatasetname
        $myrefs += $mydataset
        $rs.setitemreferences($reportpath, @($mydataset))
      }
    }
  }
}

here seemingly article on how acquires types report servies proxy: http://www.sqlmusings.com/2012/02/04/resolving-ssrs-and-powershell-new-webserviceproxy-namespace-issue/


\_(ツ)_/



Windows Server  >  Windows PowerShell



Comments

Popular posts from this blog

Group Policy Event ID 1058 Error Code 1326 (The user name or password is incorrect)

Suspicious event log Event ID: 4905

DCOM received error "2147746132" from...