topic Re: Move SSRS reports to existing PBIRS in Report Server

Move SSRS reports to existing PBIRS

cnschulz — Tue, 10 Jul 2018 23:09:02 GMT

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.

Re: Move SSRS reports to existing PBIRS

messerjc — Tue, 10 Jul 2018 15:29:38 GMT

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

Re: Move SSRS reports to existing PBIRS

cnschulz — Tue, 10 Jul 2018 23:10:47 GMT

Hi,

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

Cheers

Re: Move SSRS reports to existing PBIRS

cnschulz — Tue, 10 Jul 2018 23:34:25 GMT

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.

Re: Move SSRS reports to existing PBIRS

messerjc — Tue, 10 Jul 2018 23:35:00 GMT

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-new-powershell-commands/

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

Re: Move SSRS reports to existing PBIRS

Ccparkhill — Sat, 14 Jul 2018 08:26:57 GMT

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

Re: Move SSRS reports to existing PBIRS

messerjc — Mon, 16 Jul 2018 16:09:54 GMT

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.

Re: Move SSRS reports to existing PBIRS

cnschulz — Mon, 16 Jul 2018 22:44:17 GMT

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.

Re: Move SSRS reports to existing PBIRS

cnschulz — Tue, 31 Jul 2018 01:20:40 GMT

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

Re: Move SSRS reports to existing PBIRS

alexbransky — Mon, 15 Oct 2018 23:34:57 GMT

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.

Re: Move SSRS reports to existing PBIRS

Anonymous — Wed, 17 Oct 2018 21:18:28 GMT

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.

Re: Move SSRS reports to existing PBIRS

cnschulz — Wed, 17 Oct 2018 21:47:18 GMT

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.