topic Re: PowerShell - deploy and Update PBIX on Report Server in Report Server

PowerShell - deploy and Update PBIX on Report Server

Anonymous — Mon, 25 Feb 2019 14:29:06 GMT

Hello Community,

I have used theses lines in order to deploy a pbix file on Report Server :

$session = New-RsRestSession -ReportPortalUri http://lservername/Reports
Write-RsRestCatalogItem -WebSession $session -Path "C:\2019\mypbix.pbix" -RsFolder "/MyFolder"

It is working fine.

Now, when I need to update the bix with another version , I used the same command bellow but I am getting this error :

Write-RsRestCatalogItem : System.Exception: Failed to create catalog item: The remote server returned an error: (409) Conflict. ---> System.Net.WebException: The remote server returned an
error: (409) Conflict.
at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)
at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()
--- End of inner exception stack trace ---
At line:1 char:1
+ Write-RsRestCatalogItem -WebSession $session -Path "C:\2019\PwC Acade ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
+ FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Write-RsRestCatalogItem

Does any one please have an idea about hte command PowerShell that could update apbix previously on the Server please by a new version ?

Many thanks

Best Regards,

Asma

Re: PowerShell - deploy and Update PBIX on Report Server

Anonymous — Tue, 26 Mar 2019 10:09:40 GMT

Hi Asma,

same issue on my side, even if I put -overwrite option.
Did you find a solution ?

regards

Re: PowerShell - deploy and Update PBIX on Report Server

JimTheBIGuy — Fri, 04 Dec 2020 21:55:26 GMT

I am having the same issue. This seems to have started after the upgrade to the Power BI report server Oct 2020 version. I can run the PowerShell script on the TFS build server but it fails for several reports (not all) when I run this through the DevOps build using a build service account. It is not consistent on which reports publish and which don't reports in the same location on the report server work fine while others fail.