Migrate power BI report between two Power BI report server environment (on-premises)

[OPB12]

In our company we want to set-up a deployment startegy, we have three Power bi report server environment (dev,test,prod) . we just use power bi desktop and  Power BI report server .

Our deployment startegy will be  :

- Developpers  publish reports from the power bi desktop to the dev environment 

- Admin will migrate reports from dev to test environment

-Admin will migrate reports from test to prod environment

I try to use the Microsoft documentation Sample Reporting Services rs.exe Script to Copy Content between Report Servers - SQL Server Reportin...

It was mentionned:

1. Applies to: ✔️ SQL Server Reporting Services (2008 R2 and later) ✔️ SharePoint ✔️ Power BI Report Server
2. Items and resources the script migrates: they mention report but, in my case, I’am getting the error for the PowerBIReport  (.pbix ) (see below)

the first step is retreiving catalog item, i can see the power bi  report (ADW_adventures).

when migration start, i get errors for powerBIReport

Error:

Migrating PowerBIReport: /source/data/ADW_adventures

System.Web.Services.Protocols.SoapException: The item '/source/data/ADW_adventures' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/source/data/ADW_adventures' cannot be found.

   at Microsoft.ReportingServices.Library.ReportingService2010Impl.GetItemDefinition(String ItemPath, Byte[]& Definition)

   at Microsoft.ReportingServices.WebServer.ReportingService2010.GetItemDefinition(String ItemPath, Byte[]& Definition)

Do you have any insights why I'am getting the error? do you know if there is other solution for the deployment startegy?

Thanks 

[d_gosbell · Accepted solution]

I suspect that the applies to section is meant to indicate that PBIRS can be a target of a migration from SSRS, but I don't think it can be used as a source for that script since the rs.exe uses the old /ReportServer endpoint that only works with paginated reports.

You could probably build your own migration script using the ReportingServicesTools powershell cmdlets https://www.powershellgallery.com/packages/ReportingServicesTools/ as these do support the new REST endpoint that works with pbix based reports.

[OPB12]

hi thanks for your response, do you know if i should install the package in the report server or just in the PC?

[d_gosbell]

---

@OPB12 wrote:

hi thanks for your response, do you know if i should install the package in the report server or just in the PC?

---

You just install this on your local PC

[Shahfaisal]

It looks like the ADW_adventures data source does not exist in the destination environment. Maybe it is trying to deploy/move a report from the current environment that uses the ADW_adventures data source but the desitnation environment doesn't have that data source?

[OPB12]

I use SQL server direct query, once published i can set up the data source