SSRS to PBRS in ConfigMgr 2203

N5ZY 1

Hello all,
I need to move from SSRS on server 2012 to PBRS on server 2019 or 2022... anyway, I just wanted to confirm the process..
Also, moving from an old SQL server to a new SQL server.
I'm thinking we don't care about the SQL db.. I don't think there were any report subscriptions.
Single Primary Site, MEMCM 2203
Migrating roles off of server 2012 hosts..
Already migrated the CM_db to a new sql 2019 server, now need to migrate reporting services but also making the change to PBRS.

Export encryption keys from old SSRS
Export custom reports
Uninstall ConfigMgr Reporting point role
Take a break while ConfigMgr does its thing

Install PBRS on new server.
Setup new PBRS database on new SQL server
Import encryption keys
Install ConfigMgr Reporting point role
Import custom reports after built-in reports appear

Thanks!

Rita Hu -MSFT 9,626 Reputation points

2022-06-03T08:25:43.68+00:00

@N5ZY
Thanks for your posting on Q&A.

As far as I know, the reporting DB only contain information about reporting specific things like the reports and subscriptions. The data displayed in the reports is always pulled from the ConfigMgr DB. There is no need to migrate. In addition, we could not migrate the custom report. So we have to try to export and import the custom report manually. Why you don't just try to backup the custom reports? Then we could try to Create a new RP in PBRS and remove the old one. I thinks it is easier.

In response to your question, I will study it further. I'm not an expert in PowerBI. This may take a little time. I will come back as soon as there are any updates.

In addition, I found the following related links just for your reference:
https://learn.microsoft.com/en-us/power-bi/guidance/migrate-ssrs-reports-to-power-bi
https://www.c-sharpcorner.com/article/migrate-existing-native-ssrs-reports-to-power-bi-report-server/
Note that the link isn't from MS, just for your reference.

Hoping that other experts with relevant experience will provide effective help. Thanks for your understanding and cooperation.

Have a great weekend.

Best regards,
Rita