1

I have to servers: one with the SSRS Report Server and a second server with the Power BI Report Server.

The issue is I'm trying to migrate the SSRS Reports to the Power BI Report Server instance on a third server that I plan to unify both report databases.

As far as I understood based on a Microsoft article (Migrate a report server installation), it's possible to migrate the SSRS database to the Power BI Report Server as shown in the picture to the same instance and service (Power BI Report Server in this case):

Migrating to Power BI Report Server from SSRS (Native mode)

I've created the backup of the SSRS databases (and encryption key) and restored on the PBI server, but it's not working. If I restore only the PBI database (and its encryption key) it works fine on the destination server. On the Report Server Configuration Manager I can only set the ReportServerPBI (that I restored from the server that already runs the PBI) to have it working. If I set the ReportServer database that I've had made the backup it doesn't work.

Am I mistaken or is there any way that I can put these services in the same server/database and running under the Power BI Report Server?

Will I have to keep separate instances to have both dashboard types running?

Improve this question
0

1 Answer 1

Reset to default
0

...is there any way that I can put these services in the same server/database and running under the Power BI Report Server?

You can have SSRS and PBIRS on the same Server, but they will require their own ReportServer databases in order to run them both.

If you want to migrate your SSRS reports into PBIRS, then you need to follow the steps in the MS article. 1. Restore a copy of the SSRS database to a new server, and then 2. install PBI RS. PBI RS will update the database and retain the reports within it.

I think the article gets a little confusing as most people reading it will be migrating from SSRS to PBIRS on a different SQL Server. There isn't a lot of info about running both side by side. But it can be done.

Improve this answer
6
  • I did restore the SSRS databases into a server with the Power BI Report Server, restored the encryption key, but when I open the SSRS URL it says something went wrong. Do you have any idea what's happening? I checked permissions and everything seems to be OK.
    – Vladimir
    Commented Nov 7, 2018 at 12:41
  • Did you overwrite the ReportServer Db that PowerBi was using? Or restore it to a different name?>
    – Sir Swears-a-lot
    Commented Nov 8, 2018 at 1:05
  • I restored a ReportServer (with its respective TempDB) database that was alteady on the server with the one that is being used by another instance of SSRS. I did the same with the ReportServerPBI database and it's working.
    – Vladimir
    Commented Nov 8, 2018 at 13:00
  • So its resolved then? Well done.
    – Sir Swears-a-lot
    Commented Nov 8, 2018 at 22:54
  • It's working only on separate databases, not as the Microsoft's article suggests it would work in the same database. Thanks for helping!
    – Vladimir
    Commented Nov 9, 2018 at 12:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.