Forum Discussion

OPB12's avatar
OPB12
Frequent Visitor
4 years ago
Solved

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 deploymen...
on-premise reports
Power BI Report Server Deployment
  • d_gosbell's avatar
    d_gosbell
    4 years ago

    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.

Shahfaisal's avatar
Shahfaisal
Icon for Solution Sage rankSolution Sage
4 years ago

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's avatar
OPB12
Frequent Visitor
4 years ago

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