Forum Discussion
How to move over SSRS reports done with SQL Server 2008 R2 into Power BI Reporting Services
- Anonymous9 years ago
ehansen17 Adam Saxton (aka. Guy in a Cube) had a video (~4 minute mark) explaining that the PBIRS will likely drop end of Q2. And the Reporting Services latest blog here mentions that "You can even easily migrate your report server database and all your reports from SSRS 2008 or later to Power BI Report Server."
I believe that is all we know at this point, but it sounds like it will be a very straightforward migration that shouldn't require you to rebuild anything.
- 9 years ago
Hi ehansen17,
1) can we run a script that will push all the reports into Power BI?
Based on this article: Migrate a report server installation, if the original SSRS instance is configured in SharePoint integration, then you can utilize the rs.exe to copy content. Otherwise, we need to copy and move the report server database manually.
2) Is there a way to have these pushed reports be pre-populating with similar views or do we need to rebuild each SSRS report in Power BI?
You needd't to recreate .rdl files. Please follow the steps here to move instance: Migrating to Power BI Report Server from SSRS (Native mode).
Best Regards,
Qiuyun Yu
Hi ehansen17,
1) can we run a script that will push all the reports into Power BI?
Based on this article: Migrate a report server installation, if the original SSRS instance is configured in SharePoint integration, then you can utilize the rs.exe to copy content. Otherwise, we need to copy and move the report server database manually.
2) Is there a way to have these pushed reports be pre-populating with similar views or do we need to rebuild each SSRS report in Power BI?
You needd't to recreate .rdl files. Please follow the steps here to move instance: Migrating to Power BI Report Server from SSRS (Native mode).
Best Regards,
Qiuyun Yu
- alexbransky9 years agoFrequent Visitor
I tried following the instructions but I don't understand how to generate the rss file for the "-i" parameter. ?