topic Re: Need help Migrating Reports from SCCM (Microsoft System Center Configuration Manager) to Power Bi in Report Server

Need help Migrating Reports from SCCM (Microsoft System Center Configuration Manager) to Power Bi

Anonymous — Tue, 17 Oct 2023 08:15:04 GMT

Hi Guys,

I really need some expertise on this!

Currently we have lots of reports that were built in SSRS with data from SCCM . We are looking to migrate most of the SSRS
reports into Power BI for a unified view.

Here are some of the solutions proposed to us and we have tried.:
-Export RDL files from SSRS into PBI Service (Correct me if i am wrong, I believe this is too manual as, data needs to be uploaded all the time)
-Integrate SCCM with Power Bi Report Server (Following the link below, we tried following the steps below, but unintentionally the current SSRS report started to fail as we deleted SSRS)
Easily Integrate SCCM with Power BI Report Server (prajwaldesai.com)

Also what would be the difference between the 2 solutions proposed above? Ideally we are looking to automate the whole process in a safe and secure way!

Re: Need help Migrating Reports from SCCM (Microsoft System Center Configuration Manager) to Power Bi

Igna — Tue, 17 Oct 2023 15:55:59 GMT

Hello,

If the goal is to automate the migration you should take a look to the ReportingServicesTools. This is a library for Powershell. I have done several migrations with it and it works very well : https://github.com/microsoft/ReportingServicesTools

Igna

Re: Need help Migrating Reports from SCCM (Microsoft System Center Configuration Manager) to Power Bi

Anonymous — Wed, 18 Oct 2023 02:24:34 GMT

Hey, Igna . Appreciate your message 🙂 . We are actually looking to replace SSRS with Power Bi Report Server. But in doing so we would like to understand on the risk involved in doing so.

BR

Adrian