Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
cnschulz
Helper IV
Helper IV

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

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

 

 

 

View solution in original post

11 REPLIES 11
messerjc
Advocate IV
Advocate IV

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

 

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.

 

Hi, 

 

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

 

Cheers

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.

Be aware that some SSRS reports may render differently, there are certainly rendering differences between SSRS 2014 and 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.

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.

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

 

 

 

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.

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.

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.