Improve Reporting Services (or converge it with Power BI). SSRS hasn't been improved very much in the last versions. For many uses cases SSRS still offers features such as export to several formats (...
I apologize if this is a total newbie question since I haven't worked with SSRS since SQL Server 2005. But, after viewing all the Power Query and Power BI goodness, is it possible (or could it be possible) to create a Power Excel output from within SSRS? One of my company's departments spends hundreds of hours a year trying to produce barely interactive data-driven workbooks through Excel VBA macros so being able to create the Power Query layout in SSRS and schedule the workbook's generation would do away with all that macro work that's mostly concerned with the presentation layer!
