Creating a Reporting Services dataset based on a DAX query driven by parameter values created using MDX queries is currently a nightmare. The process is complex using the DMX editor and string expressions in order to build a dynamic DAX query to be run against a tabular model. There are significant performance benefits using DAX queries vs. MDX queries when returning detail data sets for drill through reports against a large tabular model. I believe that creating better support for DAX queries within Reporting Services would help to drive usage of Analysis Services Tabular models and help Microsoft BI users unlock the incredible capabilities of the stack. ... View more

Add dynamic actions and effects to reports to make them more interactive. There are several great examples of after-market products and projects that demonstrate what could be accomplished by adding JavaScript support to SSRS rendering, such as d3js.org. I think this is what many users consider to be a "modern" report UI. The work that Jason and his group have done at ForeRunner SW using JSON to layer JavaScript over SSRS in the rendering phase demonstrates how the current product could be enhanced in very specific ways. ... View more

In the Report builder better if we could see the fields of tables connected to any datasource in the same way connected to SQL database ... View more

Parameters are the key to building interactive reporting solutions but complex report designs can become difficult to maintain. Let's say that I have ten items on a dashboard style report that pass all the parameters back to the same report (which is necessary to maintain the state of previously-selected parameter values)... Now I add one more parameter to the report and I have to find every item with an action to add that parameter. If there were some kind of a parameter collection object, similar to the property bag in old VB or the Request/Response/Application/Cookies objects commonly used in ASP.NET; this could be used to add the new parameter to the collection and simply pass the whole thing as an object to maintain the state of previously selected values. I have several specific thoughts and examples to share on this subject. ... View more

Currenty if you want to control where the parameters should be placed you have sometimes to add additional dummy parameters. ... View more

Scaling out is the best architecture to satisfy increasing performance demand. Scaling on demand would be a great idea. ... View more

Add a checkbox for boolean parameters instead of radio buttons. ... View more

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 (PDF, Word, Excel...) which are not covered by Power BI. ... View more

Make something that looks great similar to periscope.io ... View more

SSRS is rapidly going stale. client side interactive reporting like Highcharts and dygraphs should be native to the Visual Studio SSRS environment. Stop adding the need for additional and other tools. ... View more

Support for more data sources such as OData, HDInsight/HDFS etc. Maybe converge the support/approach similar to the support in Power Query or PowerPviot. ... View more

In SSRS, the maps you design are static. We should have more functionality like dynamic zooming in and out, dynamic selection of objects on map, showing different levels of data at different level of zooming. Developers have to search online for map objects and then import it. We should have a bigger library of basic maps. ... View more

Create subscriptions for reports with OLAP data source. ... View more

Add a method by which you can see the reports you have navigated through to get where you are now. This enables you to jump back and also gives you a good idea of where you are in complex report heirarchies ... View more

Allow report designers to control the visibility or accessbility of parameters via expressions. For example based on a radio button make other parameters read-only/disabled or hidden. ... View more

Latest details on vNext say native support of WebForms will not be available and this will be delivered as an addon in future. With the change in strategy how about building a report viewer I can embed in ASP.NET MVC and/or other ASP.NET hosted frameworks? We still have to embed a webform in our MVC apps just to integrate SSRS Reports. It would be great to have proper integration and better control in ASP.NET without the need of webforms ... View more

We are exporting data to Power BI via REST API, and we can't create measures using DAX in Web designer. We need either DAX support in Power BI Web designer or ability to export datasource or report from Power BI Web to Power BI Desktop. ... View more

The current html engine renders multipage reports into a large scrollable html documents without interaction. Adding interaction (dropdown boxes, pages) for offline html rendering will help supporting offline scenario on mobile devices. ... View more

Scenario. Import a data model into Power BI (say via excel file stored on onedrive). Setup a data refresh on it. Validate that it works. Now make a schema change in the data model (say add a new table). Save the file in the onedrive location. This now breaks the data refresh from the power Bi site. It would be quite common for users to keep updating the model schema as they go. Doing that should not impact the scheduled refresh functionality. ... View more