January 27, 2026 at 2:52 pm
The word is finally out that Microsoft is no longer supporting SSRS.
I just wanted to get everyone's thoughts on this. For those working in this environment who got the same notice, what are your company's contingency plans?
Switching to Report Builder for Power BI?
Going to a different environment?
continuing with what you have until it's gone?
January 28, 2026 at 3:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
January 28, 2026 at 8:54 pm
I was reading up a little bit on this and it's not the greatest news for sure. PBIRS requires a PBI Pro license to develop reports and that doesn't come with a visual studio subscription. If you are on SQL Server 2025, you can get by with Standard and viewers require no license, but if you are on 2022 or older, you must have enterprise to use PBIRS.
To the best of my knowledge, building reports for SSRS you could use RS or VS and SSDT and as long as you had a VS subscription you were in the clear for developing and no license required for viewing.
We have no current plans to change anything, but we also are not running SQL Server 2025. When the time comes to update, we will evaluate our options and determine next steps. SSRS is still supported until 2028, so still a few years to get things sorted out. That being said, our approach will likely be to upgrade the test environment to SQL 2025 (migration upgrade so we can roll back easily if needed), install PBIRS and migrate all SSRS reports to PBIRS. If things go smoothly, we proceed to replicate on production. Developers continue to use visual studio with SSDT to build the SSRS reports then use the Power BI tools to migrate to PBIRS short term while we figure out licensing. Our hope is that MS includes a PBI Pro license for development and testing of reports similar to how they provide a bunch of other licenses (windows server, SQL server, Exchange, etc.) with a visual studio subscription but if not, we look at buying additional licenses for the reporting team.
Converting all of our existing reports to some other platform is not sustainable without automated tools and from what I've read, PBIRS can migrate SSRS reports pretty easily. On top of that, PBIRS has a similar look and feel to SSRS so end user experience will be similar. It is the easier approach especially since having the SQL Server 2025 Standard license will include PBIRS, why not use it?
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply