cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
asmarezgui
Helper I
Helper I

PowerShell - deploy and Update PBIX on Report Server

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

2 REPLIES 2
JimTheBIGuy
Helper I
Helper I

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.

Anonymous
Not applicable

Hi Asma,

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

regards

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors