Learn how to migrate your exising SQL Server Reporting Services (SSRS) instance to an instance of Power BI Report Server.
Migration is defined as moving application data files to a new Power BI Report Server instance. The following are common reasons why you might migrate your installation:
You are wanting to move from SQL Server Reporting Services to Power BI Report Server
You have a large scale deployment or update requirements
You are changing the hardware or topology of your installation
You encounter an issue that blocks upgrade
Migrating from an SSRS (Native mode) instance to Power BI Report Server consists of a few steps.
Migrating from an SSRS (SharePoint-integrated mode) to Power BI Report Server is not as straight forward as native mode. While these steps will provide some guidance, you may have other files and assets within SharePoint that will need to be managed outside of these steps.
You will need to migrate the specific report server content from SharePoint to your Power BI Report Server. This assumes you have already installed Power BI Report Server somehwere in your environment. For more information on installing Power BI Report Server, see Install Power BI Report Server.
If you want to copy the report server content from your SharePoint environment to Power BI Report Server, you will need to use tools such as rs.exe to copy the content. Below is a sample of what the script would be to copy report server content from SharePoint to Power BI Report Server.
The sample script should work against SharePoint 2010 and later and SQL Server 2008 Reporting Services and later.
Sample Script rs.exe -i ssrs_migration.rss -e Mgmt2010 -s http://SourceServer/_vti_bin/reportserver -v st="sites/bi" -v f="Shared Documents“ -u Domain\User1 -p Password -v ts=http://TargetServer/reportserver -v tu="Domain\User" -v tp="Password"
Migrating from one Power BI Reprot Server is the same process as migrating from SSRS (Native-mode).
More questions? Try asking the Power BI Community