cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
cnschulz Regular Visitor
Regular Visitor

Move SSRS reports to existing PBIRS

Gday, 

 

We have around 200 reports sitting on a 2008 R2 SSRS server. Ideally we would like to move these reports to our PBIRS running on 2012. We can't simply replace the whole ReportServer DB as there are existing PB reports on it. 

 

Can anyone point me in the direction of some automation that might copy thode 200 reports (including folder structure) to PBIRS? We have aroung 50 data sources so if we could somehow preserve credientials that would be a bonus.

 

Thanks for your time.

 

1 ACCEPTED SOLUTION

Accepted Solutions
cnschulz Regular Visitor
Regular Visitor

Re: Move SSRS reports to existing PBIRS

Solved for us: I found reportsync that works well. I used the powershell libraries to copy the data source directory first. ReportSync is smart emough to match on data source *name* and thus maintains referential integrity when copying. It was temptiong to try and move everything via powershell but I could not find a way to automtically link all the reports to their newly created data sources given the UUID's were different.

 

ReportSync: https://github.com/ghalebbadran/reportsync

Powershell documentation: https://github.com/Microsoft/ReportingServicesTools

 

 

 

11 REPLIES 11
messerjc Member
Member

Re: Move SSRS reports to existing PBIRS

This should do the trick - you're essentially doing a migration, copying (or backing up and restoring) the ReportServer database and then restoring it either to a new database or to a new SQL Server. Then install PBRIS, and after the install you go through the Config Manager, point it at the new database and away you go. The one thing I ran into recently was that it worked much more cleanly if I also moved over my ReportServerTempDB database. I don't know that it's necessary, but it seems to help smooth out the migration in our situtaiton.

 

https://docs.microsoft.com/en-us/power-bi/report-server/migrate-report-server

 

cnschulz Regular Visitor
Regular Visitor

Re: Move SSRS reports to existing PBIRS

Hi, 

 

We can't simply replace the whole ReportServer DB as there are existing PB reports on it.

 

Cheers

cnschulz Regular Visitor
Regular Visitor

Re: Move SSRS reports to existing PBIRS

If I clone my SSRS reportserver db and replace the one on the PowerBi Server with this, all I am goin to end up with is the SSRS reports. All of the powerbi reports will be gone.

 

messerjc Member
Member

Re: Move SSRS reports to existing PBIRS

Apologies! I misread your original post and didn't realize you already have the existing PBIRS running. I would take a look at something like this...

 

https://sqlserverbi.blog/2016/12/03/migrating-reports-between-ssrs-report-servers-simplified-with-ne...

 

It's focused on SSRS, but I would be hopeful that it may also work on PBIRS.

Ccparkhill Regular Visitor
Regular Visitor

Re: Move SSRS reports to existing PBIRS

Be aware that some SSRS reports may render differently, there are certainly rendering differences between SSRS 2014 and PBIRS.
messerjc Member
Member

Re: Move SSRS reports to existing PBIRS

We've noticed a few rendering differences on our more complex reports, but overall I've been very happily surprised how much of it is all working as expected.

cnschulz Regular Visitor
Regular Visitor

Re: Move SSRS reports to existing PBIRS

Cheers, 

 

Can anyone point me at a page outlining those differences? Most of our reports are strictly tabular, with some groupings. We have a few that insert barcodes and behave like mail merge for letters.

cnschulz Regular Visitor
Regular Visitor

Re: Move SSRS reports to existing PBIRS

Solved for us: I found reportsync that works well. I used the powershell libraries to copy the data source directory first. ReportSync is smart emough to match on data source *name* and thus maintains referential integrity when copying. It was temptiong to try and move everything via powershell but I could not find a way to automtically link all the reports to their newly created data sources given the UUID's were different.

 

ReportSync: https://github.com/ghalebbadran/reportsync

Powershell documentation: https://github.com/Microsoft/ReportingServicesTools

 

 

 

alexbransky Frequent Visitor
Frequent Visitor

Re: Move SSRS reports to existing PBIRS

Can you explain in more detail?  I have tried downloading the rsds files from Reporting Services in SharePoint using PowerShell and that works but then I can't upload them.  I can get the rdl files up to PBIRS just fine but not the data sources.