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 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?
Here is the link to the migration script:
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:
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?
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"
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...
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
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 |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
6 | |
3 | |
3 |