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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Migrating all PowerBI content from one server to another

Hi guys,

 

I have 2 PowerBI report Servers; one runs on March 2018 (Server A) version and the Other runs on May 2019 (Server B) version, and I want to move all the contents from Server A to Server B.

 

There is a lot of reports in the first Server (over 500 reports) and most of the reports are linked to each other; and I dont want to do this process manually as it will be time consuming.

 

Can restoring the ReportServerPBI database of Server A to Server B do the tricks for me.

 

Please advise, thanks

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User


@Anonymous wrote:

 

Can restoring the ReportServerPBI database of Server A to Server B do the tricks for me.

 


This might be dangerous as there are probably database changes between March 2018 and May 2019. If Server B is not currently used then you could uninstall the May 19 version, then install the March 18 version, restore the database, then upgrade the Server B instance to May 19.

 

Or you could write some powershell scripts using the ReportingServicesTool module to export all your reports from server A (using something like Out-RSRestFolderContents) to a folder somewhere then upload them to Server B (using something like Write-RsRestFolderContents). But you'll need to test this as I know this works with pbix and rdl reports, but I'm not 100% sure if this picks up linked reports or not.

View solution in original post

6 REPLIES 6
d_gosbell
Super User
Super User


@Anonymous wrote:

 

Can restoring the ReportServerPBI database of Server A to Server B do the tricks for me.

 


This might be dangerous as there are probably database changes between March 2018 and May 2019. If Server B is not currently used then you could uninstall the May 19 version, then install the March 18 version, restore the database, then upgrade the Server B instance to May 19.

 

Or you could write some powershell scripts using the ReportingServicesTool module to export all your reports from server A (using something like Out-RSRestFolderContents) to a folder somewhere then upload them to Server B (using something like Write-RsRestFolderContents). But you'll need to test this as I know this works with pbix and rdl reports, but I'm not 100% sure if this picks up linked reports or not.

Anonymous
Not applicable

@d_gosbell I forgot to mention, I had to upgrade both servers to May 2019 before restoring the databases and encryption key. 

 

The idea is to use this as a future approach.


@Anonymous wrote:

@d_gosbell I forgot to mention, I had to upgrade both servers to May 2019 before restoring the databases and encryption key. 

 

The idea is to use this as a future approach.


Yes, once both servers are on the same version you can backup/restore the database and encryption key. But it's the installer that upgrades the database schema from one release to the next so it could be dangerous to just restore a database from a different version.

Anonymous
Not applicable

I was able to do this by restoring the ReportServerPBI and ReportServerTempPBI databases as well as the encryption key of ServerA to ServerB.

Even though this is an older thread, I thought I'd see if someone could answer.  How are agent jobs (refresh jobs?) migrated over when you restore the main and tempdb databases?  Or are they?

 

Or do you have to restore the msdb database from the source server also?

 

Thanks!


@abrownfl wrote:

How are agent jobs (refresh jobs?) migrated over when you restore the main and tempdb databases?  Or are they?

 


The schedule definitions are also stored in the ReportServer database. It appears that when the Report Server services restart that there is a process that checks that all the expected agent jobs are present and will re-create them if they are not.

 

Our DBAs recently moved our dev server to a new Availability Group and we noticed that when the database was failed over from the primary to the secondary node the scheduled jobs did not exist. In the documentation for Report Server it states that after an AG failover you need to restart the Report Server service. After we did this all the agent jobs got created on the secondary node.

 

So after you attach the new ReportServer instance to the recovered database I think it should re-create the agent jobs, if not restarting the service should do this.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors