Move SSRS reports to existing PBIRS

[cnschulz]

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.

[messerjc]

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]

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.

[cnschulz]

Hi, 

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

Cheers

[messerjc]

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]

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

[messerjc]

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]

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 · Accepted solution]

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]

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.

[u02cm62]

I don't think Shared data sources are supported yet.  I know in SSRS in the cloud they are not supported but there are plans to support them.

[cnschulz]

Shared data sources are supported, please read the solution document. Copy the datasources via powershel and then use reportsync for the reports. It matches on *name* not uuid which is awesome.