Forum Discussion
Migrate power BI report between two Power BI report server environment (on-premises)
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
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.
5 Replies
- d_gosbell
Super User
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.
hi thanks for your response, do you know if i should install the package in the report server or just in the PC?
ShahfaisalSolution Sage
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?
I use SQL server direct query, once published i can set up the data source
