It is well known that SSRS is not easily usable for the average business user, especially for self-service reporting use-case. Modern BI tools offer more advanced and interactive data visualization capabilities compared to SSRS. They can create dynamic charts, graphs, dashboards, and interactive tabular reports that make it easier for users to understand and explore data.
Another reason to replace SSRS are embedded reports: ReportViewer supports only legacy .NET Framework apps and you simply cannot keep SSRS reports in modern .NET Core apps.
A maintainance of many user-created SSRS reports may be difficult and painful; if you stuck with an old version of SSRS an upgrade also might need significant efforts.
Choosing the right replacement for SQL Server Reporting Services highly depends on the way how SSRS reports are used exactly in your company. In other words, you need to get clear understanding your organization's reporting requirements. This includes an identification of key features and functionalities that are must-have for your reports, such as data connectivity, visualization options, collaboration, and security.
|Embedded reports with parameters
|SeekTable reports/dashboards can be embedded into any web application (including SaaS apps).
|If you find that your embedded usage requires PowerBI Premium (or just on-premises deployment) it becomes $$$.
|Self-service reporting for non-IT users
|Metabase on-prem is free. Easy to use, simple interface.
|Good for tabular reports / exports. Viewers are free users.
|A BI market leader. Can be expensive if you have many report viewers (per-user pricing).
|Very good for low technically proficient users. Perfect for data visualization. Can be expensive if you have many report viewers (per-user pricing).
|Custom reports for printing with free-form layout
|SeekTable custom dashboards
|In SeekTable dashboards are controlled via HTML template which also affects PDF export output. This makes it possible to have a very custom PDF output (see this example).
|PBI Reports Builder
|PBI paginated reports are in fact modernized SSRS that is now a part of PowerBI.