Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
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
Solved! Go to 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.
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?
@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
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