Forum Discussion

ehansen17's avatar
ehansen17
New Member
9 years ago
Solved

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

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 fast...
  • Anonymous's avatar
    Anonymous
    9 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.

  • v-qiuyu-msft's avatar
    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