Somewhere in mid 2017 Microsoft will release a new version of SQL Server in which we will have an integration with Power BI. This means we will (I hope) be able to use SSRS as an on premise solution to host Power BI reports, as you can read here on the SQL Server Reporting Services Team Blog:
Power BI reports in SQL Server Reporting Services: Feedback on the Technical Preview
It will be released in a production-ready version in the next SQL Server release wave, and not in a Service Pack, Cumulative Update, or other form of update for SSRS 2016.
This sounds really exciting and in my opinion it’s one of the last pieces of the Power BI puzzle that was missing.
Of course you don’t have to wait to get involved.
How can I participate today?
The best way to participate and help us deliver SSRS with Power BI reports as quickly as possible is to try our preview releases and share your feedback:
- Get the Technical Preview from the Azure Marketplace
- Post in the Reporting Services forum
- Join the conversation on Twitter: @SQLServerBI, #SSRS
Technical Preview of Power BI reports in SQL Server Reporting Services now available
Create Power BI reports in the SQL Server Reporting Services Technical Preview
Announcing a Technical Preview of Power BI reports in SQL Server Reporting Services