With one of our clients, we're currently faced with a dilemma. SQL Server Reporting Services Report Server (SharePoint mode) seems to have been deprecated, since the last version to support it is SQL Server 2016.
Now our client wants SharePoint integration with Reporting Services and SQL Server 2016 is currently supported, so there is the option to go that route. I just feel uneasy building something for a client with a technology that is essentially dead.
So, I've been researching on what sort of options there are going forward (SQL Server 2017 onwards). An article by John White pointed out that this is a good thing, because it allows for SSRS Native mode to be more tightly integrated into SharePoint. But his article is from the end of 2016 and points at future improvements that I'm battling to see.
Microsoft's own SQL Stream Blog addresses this issue in November 2016, with mention of three scenarios that they planned to focus on going forward. Namely: Embedding reports in SharePoint pages; Reporting on data in SharePoint lists; and Delivering reports to SharePoint libraries.
What I can find from Microsoft after that date is sparse. I only found one other article on the SQL Server Blog that mentions SharePoint, with the announcement of a "Report Viewer web part".
My question is, has anyone faced this dilemma before? And how what solution did you go with?
I know we can work with PowerShell scripts and create embedded reports on SharePoint, but it doesn't seem very elegant considering what "SharePoint mode" was.
EDIT: I realise I asked a question that warrants an answer that's more of an opinion than a fact. What I am interested in, is approaching Report Server – SharePoint integration from a SQL Server 2017 and newer perspective.