topic Re: Migration of Power BI Report Server On-Premises from older version a new in Report Server https://community.fabric.microsoft.com/t5/Report-Server/Migration-of-Power-BI-Report-Server-On-Premises-from-older/m-p/4728203#M41072 <P>Hey&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="520989" data-lia-user-login="tamiribas" class="lia-mention lia-mention-user">tamiribas</a>&nbsp;,</P><P>Migrating Power BI Report Server (PBIRS) from an older version (e.g., January 2022) to a newer one (e.g., May 2025) on a new machine requires a well-structured approach to ensure all <STRONG>reports, schedules, subscriptions</STRONG>, and <STRONG>configuration settings</STRONG> are retained accurately. Below is a guide outlining the <STRONG>best practices and steps</STRONG> to perform the migration safely and effectively.</P><H2><FONT color="#000000"><STRONG>Migration Strategy for PBIRS (On-Premises)</STRONG></FONT></H2><H3><FONT color="#000000"><STRONG>1. Pre-Migration Preparation</STRONG></FONT></H3><UL><LI><P><STRONG>Backup the PBIRS databases</STRONG>:</P><UL><LI><P>ReportServer</P></LI><LI>ReportServerTempDB</LI></UL></LI><LI><STRONG>Backup the encryption key</STRONG><SPAN> using the Report Server Configuration Manager.</SPAN></LI><LI><P><STRONG>Backup the ReportServer config files</STRONG>:</P><UL><LI>rsreportserver.config</LI><LI><P>rssrvpolicy.config</P></LI><LI><P>web.config (under Report Manager and Web Portal folders)</P></LI></UL></LI></UL><H3><FONT color="#000000"><STRONG>2. Install the New PBIRS (May 2025) on New Server</STRONG></FONT></H3><UL><LI><P>Install the May 2025 version on the new machine.</P></LI><LI><P>Open Report Server Configuration Manager.</P><UL><LI><P>Choose "Connect to an existing report server database".</P></LI><LI><P>Point to the backed-up ReportServer and ReportServerTempDB databases.</P></LI></UL></LI><LI><P><STRONG>Restore the encryption key</STRONG> using the .snk file backed up earlier.</P></LI><LI><P>Ensure <STRONG>Web Portal and Web Service URLs</STRONG> are configured and accessible.</P></LI></UL><H3><FONT color="#000000"><STRONG>3. Transfer Custom Settings</STRONG></FONT></H3><UL><LI><P>Manually compare and merge configurations from the old rsreportserver.config and other files into the new server (only if customized settings are needed).</P></LI><LI><P>Reconfigure email settings, execution logs, and delivery extensions if any.</P></LI></UL><H3><FONT color="#000000"><STRONG>4. Validate Migration</STRONG></FONT></H3><UL><LI><P>Log in to the web portal and check:</P><UL><LI><P>All 100 reports are present.</P></LI><LI><P>Data sources are correctly linked and functional.</P></LI><LI><P>Scheduled refreshes and subscriptions are retained.</P></LI></UL></LI><LI><P>Run test subscriptions to verify delivery mechanisms.</P></LI><LI><P>Check any custom branding or settings applied earlier.</P></LI></UL><P>&nbsp;</P><H2><FONT color="#000000"><STRONG>Alternative: Use PBIRS Migration Scripts or PowerShell</STRONG></FONT></H2><P>If a full DB move isn’t viable (e.g., partial migration or report selection needed), you can:</P><UL><LI><P>Use PowerShell scripts or Report Server Web Service endpoints to&nbsp;extract and redeploy reports.</P><UL><LI><P>Script options: <A href="https://github.com/microsoft/ReportingServicesTools" target="_blank" rel="noopener">Export-RsCatalogItems</A></P></LI><LI><P>Use RS.exe utility for command-line publishing.</P></LI></UL></LI></UL><H2><FONT color="#000000"><STRONG>For more information:</STRONG></FONT></H2><UL><LI><P><A href="https://learn.microsoft.com/en-us/sql/reporting-services/report-server/migrate-a-reporting-services-installation" target="_blank" rel="noopener">Microsoft Docs – Migrate Report Server</A></P></LI><LI><P><A href="https://learn.microsoft.com/en-us/sql/reporting-services/install/backup-and-restore-reporting-services" target="_blank" rel="noopener">Microsoft Docs – Backup and Restore Reporting Services</A></P></LI></UL><P>&nbsp;</P><P><STRONG>If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.</STRONG></P><P><BR />Best Regards,<BR /><A href="https://www.linkedin.com/in/nasif-azam-9aa2331a0/" target="_blank" rel="noopener nofollow noreferrer">Nasif Azam</A></P> Wed, 11 Jun 2025 07:54:30 GMT Nasif_Azam 2025-06-11T07:54:30Z Migration of Power BI Report Server On-Premises from older version a new https://community.fabric.microsoft.com/t5/Report-Server/Migration-of-Power-BI-Report-Server-On-Premises-from-older/m-p/4727657#M41069 <P>Hello,</P><P>A client is using the Power BI Report Server On-Premises version (January 2022).&nbsp; They have 100 active reports on the server.</P><P>We have installed a new version of&nbsp;Power BI Report Server On-Premises&nbsp; (May 2025) on a new machine.</P><P>We need to migrate all reports, schedules, and subscriptions.</P><P>&nbsp;</P><P>Is there a guide for best practices?</P><P>&nbsp;</P><P>Thank you,m</P><P>Tamir</P> Tue, 10 Jun 2025 18:19:58 GMT https://community.fabric.microsoft.com/t5/Report-Server/Migration-of-Power-BI-Report-Server-On-Premises-from-older/m-p/4727657#M41069 tamiribas 2025-06-10T18:19:58Z Re: Migration of Power BI Report Server On-Premises from older version a new https://community.fabric.microsoft.com/t5/Report-Server/Migration-of-Power-BI-Report-Server-On-Premises-from-older/m-p/4728203#M41072 <P>Hey&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="520989" data-lia-user-login="tamiribas" class="lia-mention lia-mention-user">tamiribas</a>&nbsp;,</P><P>Migrating Power BI Report Server (PBIRS) from an older version (e.g., January 2022) to a newer one (e.g., May 2025) on a new machine requires a well-structured approach to ensure all <STRONG>reports, schedules, subscriptions</STRONG>, and <STRONG>configuration settings</STRONG> are retained accurately. Below is a guide outlining the <STRONG>best practices and steps</STRONG> to perform the migration safely and effectively.</P><H2><FONT color="#000000"><STRONG>Migration Strategy for PBIRS (On-Premises)</STRONG></FONT></H2><H3><FONT color="#000000"><STRONG>1. Pre-Migration Preparation</STRONG></FONT></H3><UL><LI><P><STRONG>Backup the PBIRS databases</STRONG>:</P><UL><LI><P>ReportServer</P></LI><LI>ReportServerTempDB</LI></UL></LI><LI><STRONG>Backup the encryption key</STRONG><SPAN> using the Report Server Configuration Manager.</SPAN></LI><LI><P><STRONG>Backup the ReportServer config files</STRONG>:</P><UL><LI>rsreportserver.config</LI><LI><P>rssrvpolicy.config</P></LI><LI><P>web.config (under Report Manager and Web Portal folders)</P></LI></UL></LI></UL><H3><FONT color="#000000"><STRONG>2. Install the New PBIRS (May 2025) on New Server</STRONG></FONT></H3><UL><LI><P>Install the May 2025 version on the new machine.</P></LI><LI><P>Open Report Server Configuration Manager.</P><UL><LI><P>Choose "Connect to an existing report server database".</P></LI><LI><P>Point to the backed-up ReportServer and ReportServerTempDB databases.</P></LI></UL></LI><LI><P><STRONG>Restore the encryption key</STRONG> using the .snk file backed up earlier.</P></LI><LI><P>Ensure <STRONG>Web Portal and Web Service URLs</STRONG> are configured and accessible.</P></LI></UL><H3><FONT color="#000000"><STRONG>3. Transfer Custom Settings</STRONG></FONT></H3><UL><LI><P>Manually compare and merge configurations from the old rsreportserver.config and other files into the new server (only if customized settings are needed).</P></LI><LI><P>Reconfigure email settings, execution logs, and delivery extensions if any.</P></LI></UL><H3><FONT color="#000000"><STRONG>4. Validate Migration</STRONG></FONT></H3><UL><LI><P>Log in to the web portal and check:</P><UL><LI><P>All 100 reports are present.</P></LI><LI><P>Data sources are correctly linked and functional.</P></LI><LI><P>Scheduled refreshes and subscriptions are retained.</P></LI></UL></LI><LI><P>Run test subscriptions to verify delivery mechanisms.</P></LI><LI><P>Check any custom branding or settings applied earlier.</P></LI></UL><P>&nbsp;</P><H2><FONT color="#000000"><STRONG>Alternative: Use PBIRS Migration Scripts or PowerShell</STRONG></FONT></H2><P>If a full DB move isn’t viable (e.g., partial migration or report selection needed), you can:</P><UL><LI><P>Use PowerShell scripts or Report Server Web Service endpoints to&nbsp;extract and redeploy reports.</P><UL><LI><P>Script options: <A href="https://github.com/microsoft/ReportingServicesTools" target="_blank" rel="noopener">Export-RsCatalogItems</A></P></LI><LI><P>Use RS.exe utility for command-line publishing.</P></LI></UL></LI></UL><H2><FONT color="#000000"><STRONG>For more information:</STRONG></FONT></H2><UL><LI><P><A href="https://learn.microsoft.com/en-us/sql/reporting-services/report-server/migrate-a-reporting-services-installation" target="_blank" rel="noopener">Microsoft Docs – Migrate Report Server</A></P></LI><LI><P><A href="https://learn.microsoft.com/en-us/sql/reporting-services/install/backup-and-restore-reporting-services" target="_blank" rel="noopener">Microsoft Docs – Backup and Restore Reporting Services</A></P></LI></UL><P>&nbsp;</P><P><STRONG>If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.</STRONG></P><P><BR />Best Regards,<BR /><A href="https://www.linkedin.com/in/nasif-azam-9aa2331a0/" target="_blank" rel="noopener nofollow noreferrer">Nasif Azam</A></P> Wed, 11 Jun 2025 07:54:30 GMT https://community.fabric.microsoft.com/t5/Report-Server/Migration-of-Power-BI-Report-Server-On-Premises-from-older/m-p/4728203#M41072 Nasif_Azam 2025-06-11T07:54:30Z Re: Migration of Power BI Report Server On-Premises from older version a new https://community.fabric.microsoft.com/t5/Report-Server/Migration-of-Power-BI-Report-Server-On-Premises-from-older/m-p/4729648#M41086 <P>Hi,</P><P>Thank you for the reply. Is this based on your experience?</P><P>&nbsp;</P><P>Thank you,</P><P>Tamir</P> Thu, 12 Jun 2025 07:17:28 GMT https://community.fabric.microsoft.com/t5/Report-Server/Migration-of-Power-BI-Report-Server-On-Premises-from-older/m-p/4729648#M41086 tamiribas 2025-06-12T07:17:28Z Re: Migration of Power BI Report Server On-Premises from older version a new https://community.fabric.microsoft.com/t5/Report-Server/Migration-of-Power-BI-Report-Server-On-Premises-from-older/m-p/4729704#M41090 <P>If your question is for me, My answer is:</P><P>My first 3 options are based on my work experience and also my failure. So you can rely on those options to find the best practices.</P><P>&nbsp;</P><P><STRONG>If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.</STRONG></P><P><BR />Best Regards,<BR /><A href="https://www.linkedin.com/in/nasif-azam-9aa2331a0/" target="_blank" rel="noopener nofollow noreferrer">Nasif Azam</A></P> Thu, 12 Jun 2025 07:46:44 GMT https://community.fabric.microsoft.com/t5/Report-Server/Migration-of-Power-BI-Report-Server-On-Premises-from-older/m-p/4729704#M41090 Nasif_Azam 2025-06-12T07:46:44Z