Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
7 | |
5 | |
3 | |
3 |