Forum Discussion
Need help Migrating Reports from SCCM (Microsoft System Center Configuration Manager) to Power Bi
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!
2 Replies
- Igna
Resolver III
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
- AnonymousNot applicable
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