Migrate SSRS 2008 reports to Power BI server (March 2018 Version).

[arun_1047]

We are planning to migrate~500 SSRS 2008 reports to Power BI server (March 2018 Version). Is there any way to move the reports,Shared Datasource & Subscriptions using the automated process?

[mgmeyer]

Here is the link to the migration script:

https://github.com/Microsoft/sql-server-samples/tree/master/samples/features/reporting-services/ssrs...

However I think there is an easier way to migrate your server, you can follow the steps here to migrate your SSRS catalog and attached it to PBIRS, this approach will allow you to keep all your encrypted content:

https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/upgrade-and-migrate-reportin...

Just make sure you don't have both SSRS and PBIRS pointing to the same DB at the same time. Also which version of SSRS are you migrating from 2008 or 2008 R2?

[arun_1047]

I am trying to move the SSRS 200R2 reports to Power BI Server.

I have used SSRS Migration.rss as mentioned in the link. I was a able to  migrate the reports, However the Shared Data source and Subscriptions were error out. The data source connection  is "SQL"

Connection Type: Microsot SQL Server

Connection String:

Data Source=ServerName;Initial Catalog=DBName

rs.exe -i ssrs_migration.rss -e Mgmt2010 -s http://Source Server/reportserver -u "Domain\UserId" -p "Password" -v f="/SourceFolderPath" -v ts="http://Target Server/reportserver" -v tu="Domain\UserId" -v tp="Password" -v tf="/TargetFolderPath"

[Anonymous]

It should be mentioned, that the passwords from shared data sources and subscriptions can not be migrated. The data source is migrated but you have to enter the passwords again. Had to do the same, some work on a machine with over 300 reports...

[Anonymous]

You should look for the SSRS Migration Script on the web. We used the same script to move several 2008 SSRS instances to a single PBIRS instance. Worked like a charme, the folder structure, data sources and even subscriptions have been moved without any problem. 

One thing to keep in mind, the script is not able to transfer login information and passswords. You have to fill it after migration. But the migration script tells you the pitfalls, if necessary, was a great help.

best regards,

Thomas