How to move over SSRS reports done with SQL Server 2008 R2 into Power BI Reporting Services

[ehansen17]

Our company is in consumer electronics where we send SSRS reports VIA email to retailers we do business with.  With the new Power BI Premium and Reporting Services, I'm looking to understand the fastest way in which we can migrate all of these reports over into Power BI.

My two major questions are 1) can we run a script that will push all the reports into Power BI? and 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?

[Seth_C_Bauer · Accepted solution]

@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.

[v-qiuyu-msft · Accepted solution]

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

[alexbransky]

I tried following the instructions but I don't understand how to generate the rss file for the "-i" parameter.  ?

[Seth_C_Bauer · Accepted solution]

@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.