Fabric Ideas

Add an OData Extension so SSRS can easily access such data sources ... View more

I have several smaller customers who have needed something like the old report models. Obviously they would need to be a bit better than they were and would need to be queryable by tools other than just SSRS / Report Builder. Ideally some sort of exploration of the model from within Excel. ... View more

Enjoy! http://prologika.com/CS/blogs/blog/archive/2015/02/05/my-wish-list-for-sql-server-vnext.aspx ... View more

Add spatial data types as attributes which can then be added to visualizations. For example drag in custom polygons to overlay on maps rather than rely on PowerMap geocoding. ... View more

As sad as it is, there needs to be focus on one way forward - that appears to be tabular. A migration path is needed, but having the two models is confusing and becoming unnecessary. Even if full support for MD features is not available I think this should still happen. ... View more

Today SSAS generates the TSQL when dimension and facts are loaded. BISM Tabular allows You to enter your own queries. The SSAS generated SQL is not the best and in order to do optimization in the loading scenarios you should be allowed to enter your own queries. ... View more

Create a data modeling Language based on a textual representation (such as SQL DML, no XML) that would enable comparison between versions and easy copy/paste between data models ... View more

Remove the requirement to have powerview require SharePoint integration. Use power view as the experience for self service and remove report builder. This way we have symmetry between on premise and our cloud PowerBi offering ... 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

A truly functional BI solution requires every dashboard, report or navigation UI to work together. This means that we need the ability to define actions and pass context information from one report interface to another - and there are far too many ways to do this in limited ways that don't work consistently across the products in the "integrated" BI arsenal. In my perfect world, I define a cube action in SSAS (multi or Tabular) and that action gets surfaced in whatever reporting tool we choose to use (Excel/Excel Services, SSRS, Power View or Power BI dashboard). Through whatever action/parameter mechanism, the user is able to click, hover, hold and tap and use the action to navigate to another (SSRS/Excel/PV/web) report in the context of their filter and selection choices. ... 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

Please make SSRS available as a Power BI functionality and not just as an integration from on premises o to PBI. I believe this would make more sense for many customer requesting the feature, and it does go in line with our cloud first motto, or at lest would reduce the gap we still see in PBI today ... View more

NULL ... View more

Design templates available for the user to select from when creating a new report. Eg, are having separators (could be image based). Snapping and guiding lines like in powerpoint. Auto-format option to auto adjust and auto align charts. ... View more

Customers request to be able to select a chart -like in excel and export the tabular data for additional analysis. ... View more

Adding features like the Predictive Analytics in PowerBI by dragging line charts using time series algorthims. Got a customer request to be able to do on the fly calculations from within PowerView. For eg, creating a new calculation for Profit without having to open powerpivot. Creating What-IF scenarios by using variables with preset or customizable values. For eg, Markup % variable with values of 10%, 20%, 30%. The end user would be able to select those values or enter another custom value in the filters pane to see the impact on the values in the dashboard. ... View more

Similar with PowerBI, when clicking a chart on the high level view, it would take the user to a more detailed powerview report. ... View more

Ability to define data driven 'alerts's like in SSRS or subscribe to an interactive "copy of the report". For eg, getting a copy in PowerBI Designer format so the report is still interactive for that days data. ... View more

Ability to format table/matrix with colors. Dimension based color control on charts. Adhoc color based formatting, selecting a part of pie and changing the color. ... View more