topic Migrate power BI report between two Power BI report server environment (on-premises) in Report Server

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

OPB12 — Wed, 19 Oct 2022 14:57:45 GMT

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 Reporting Services (SSRS) | Microsoft Learn

It was mentionned:

Applies to: ✔️ SQL Server Reporting Services (2008 R2 and later) ✔️ SharePoint ✔️ Power BI Report Server
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

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

Shahfaisal — Wed, 19 Oct 2022 23:39:03 GMT

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?

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

d_gosbell — Wed, 19 Oct 2022 23:44:09 GMT

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.

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

OPB12 — Mon, 24 Oct 2022 13:52:01 GMT

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

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

OPB12 — Mon, 24 Oct 2022 13:53:26 GMT

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

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

d_gosbell — Mon, 24 Oct 2022 19:54:11 GMT

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