Forum Discussion
Power BI Report Server Disaster Recovery
Lorenz33 wrote:
I would like to enquire about Disaster Recovery. In the event of a server crash, would we be able to do a new install of Power BI Report Server on another server and then restore the Power BI Report Server database? Would the folder structure and permissions also be recovered?
Yes, the database contains all the reports, folder structures, permissions etc. The only other thing you need to back up is the encryption keys. If you run the Report Server Configuration Tool there is an option in there to back up the encryption key.
The encryption key is used to encrypt any user credentials that are stored in the report server database. Without the encryption keys you would have to go through any data sources using stored credentials and re-enter the username/passwords.
The only other thing you might need to consider backing up are any of the config files if you have made any changes to those.
Power BI Report Server is really just an extended version of SQL Server Reporting Services. So you can use the recovery documentation for SSRS as a guide for Power BI Report Server.