Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

New Member

Automating Migration between Power BI Report Servers using ssrs_migration.rss

Hello Community,

I am in the process of migrating content from one Power BI Report Server to another and am looking to automate this task to avoid recreating folder structures, permissions, and re-uploading reports manually. I came across the `ssrs_migration.rss` script provided by Microsoft and am considering using it for this purpose.

From my understanding, the script can:
- Migrate content elements and settings between Power BI Report Servers.
- Migrate various items such as Power BI reports, subscriptions, history settings, and schedules (provided SQL Server Agent is running on the target server).
- Migrate permissions if using the SECURITY switch, with specific limitations and considerations.

However, it seems that the script cannot:
- Migrate passwords, requiring a manual update of credentials on the destination server.
- Replace existing content elements with the same name on the destination server.
- Migrate historical information, although history settings are migrated.

Additionally, manual steps would be needed to manage name conflicts for existing items on the destination server and to verify roles and permissions, especially if a role already exists on the destination server.

I also noted that PowerShell Reporting Services commands like `Out-RsRestFolderContent` and `Write-RsRestFolderContent` can be used as an alternative or supplement for migrating Power BI reports.

I would like to ask if anyone has experience using the `ssrs_migration.rss` script for migrating content between Power BI Report Servers and can confirm my understanding of its capabilities and limitations. Also, are there any other recommendations or best practices for automating the migration process between Power BI Report Servers?

Thank you in advance for your insights and advice!

Best Regards,


Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.