Forum Discussion
Helper IVSsrs with sharepoint
Hello
i am searching about solution for my client
they have reports (arround 200 reports) with ssrs (version 2014)
the reports are deployed on sharepoint on premise version
they would like to migrate to recent version of sql but the problem is sharepoint, What can I suggest for that?
Also is it better to stay on ssrs or to migrate to power bi report server?
'is there solution to migrate the reports automatically from ssrs to power bi ?
thank you in advanced for your help
Sli
Since SharePoint-integrated mode is no longer supported in recent SQL versions, your client should move SSRS to Native mode if they want to upgrade. If they’re open to modernization, Power BI Report Server (PBIRS) is a better choice as it supports both SSRS and Power BI reports.
There’s no automatic migration from SSRS to Power BI. SSRS paginated reports can be imported into PBIRS, but converting them to interactive Power BI reports requires manual redesign.
2 Replies
- Fowmy
Super User
Since SharePoint-integrated mode is no longer supported in recent SQL versions, your client should move SSRS to Native mode if they want to upgrade. If they’re open to modernization, Power BI Report Server (PBIRS) is a better choice as it supports both SSRS and Power BI reports.
There’s no automatic migration from SSRS to Power BI. SSRS paginated reports can be imported into PBIRS, but converting them to interactive Power BI reports requires manual redesign.
SLIVery clear thank you very much