Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We have Power BI Report Server set up at our organization. We are currently using the May 2021 version and have it installed on the same server where SQL Server is installed (where the ReportServer databases are located). In SQL Server, the Power BI Report Server database has a daily full backup and hourly transaction log backups.
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?
What are the best practices for disaster recovery for Power BI Report Server?
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
7 | |
4 | |
3 | |
2 |
User | Count |
---|---|
15 | |
11 | |
5 | |
5 | |
2 |