Today that option exists in Data Tools in Visual Studio but it is not working. You get a message that it is not supported. ... View more

Currently the SSAS Tabular engine doesn't process partitions in the same table in parallel when loading data into the model. This is a major limiting factor on very large models. ... View more

Integrate SSIS with the Power Query Excel Add-In as a Data Source. Solution needs to be all on-prem to avoid typical cloud concerns. Ideally can reach into a workbook for a specific Query or function, pass in function values if required, and trigger a refresh of a Query or all Queries. ... View more

I want to build the DAX for a Month-to-Date member of a Date Calculation dimension and have it apply to every measure in the model. This would require scope statements to do in a maintainable way. ... View more

Currently Tabular models don't scale well on servers with multiple NUMA nodes. Proper NUMA support should be built in as it is for Multidimensional models. This can be a limiting factor for very large models. ... View more

Fix drillthrough in SSAS Multidimensional and Tabular. It needs to work with calculations (which means that devs can use MDX or DAX expressions that specify the rows returned when a user drills through on a calculation). We also need to be able to return user-friendly column names and control column order. ... View more

When exporting from SSRS to Word, the resulting document always has a "Normal" style font of Times New Roman. In a common scenario, a report is exported from SSRS to Word, then an analyst/author uses Word to add commentary. If they click in any empty area and start typing, the "Normal" style will be applied with Times New Roman font. Ideally this could be set as a Report-level Property and passed to Word during the export process. ... View more

There are a couple of scenarios where column widths are not respected when exporting to Word. The most common is where a nested table has a column with "narrow" content - the column width sometimes shrinks to contents. The other is when a column contains a long word with no spaces or breaking characters - the Word column width is increased to the width of that word. ... View more

For SSRS Text Box controls, add a "Justify" option for the Horizontal/TextAlign property. This would produce fully justified text, as in Word. This feature supports automated production and distribution of documents of publication quality. This has been an open Connect item for over 5 years, gathering over 500 votes: https://connect.microsoft.com/SQLServer/feedback/details/404966/full-justification-in-reporting-services-2008-needed ... View more

The example I have is I'm working with a ~300MB CSV file. Every time I make any transforms on the file in Power Query, it goes and fully retrieves the CSV, performs the transform, then dumps it out again. Needless to say this gets really tedious in development mode. It would be nice to be able to cache a dataset in memory, sacrificing real-time access to the data for performance while in Power Query (and perhaps Power View as well.) ... View more

Many developers abandon SSAS Tabular (after their companies pay for enterprise licensing to get it) because of the development experience and they reason that if the development experience is poor that the product may be just as unreliable. The model designer has many problems and quirky behaviors when the model becomes complex (typically due to the number of tables & measures). In particular, the DAX editor can be very unwieldy. The auto-completion feature can cause more mistakes than it prevents. For example, if you were to backspace over a table and column, and then use the object list to select a different object; the editor makes a horrible mess by combing the old and new text. Some examples: In trying to replace 'First Table'[First Column] with 'Second Table'[Second Column] the editor may produce: 'First Table'[First Co[Second Column]lumn] or ''Second Table'[Second Column]. Given the small font and text size in the editor, users miss the doubled-up single quotes. When an error is reported, changes are lost; developers become angry & moody and are mean to people around them. After making changes to an expression and pressing Enter to save changes, the editor shows the previous expression, causing the developer to think that changes were lost which makes them throw things and use bad words. While you're at it, add support for comments and tabs. I suggest a usability test be conducted and observed using a production-scale project. ... View more

Buggy behaviors in RB make users give up (especially less-technical business users who this tool was designed for). The rest of us just get angry. These include: - Sometimes (inconsistently), pressing Enter will close the expression window and other time is adds a carriage return. - VB functions are (sometimes) translated to full-qualified object references which confuses users. - Certain field properties are changed when a data region is copied and pasted (example .UniqueName is changed to .Value) - Expression window just hangs & then crashes. ... View more

Add real-time dashboards which update continously like http://www.tweetping.net/ or the Twitter CEP demo application of the MTC Signapur. Maybe with a built-in or an easy integration with StreamInsight or Azure Stream Analystics. ... View more

Add more export formats (such as PDF, Word...) for Power View dashboards/reports. If possible server side generated similar to the data driven subscriptions in SSRS. ... View more

Currenty if you want to control where the parameters should be placed you have sometimes to add additional dummy parameters. ... 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

Consolidate the visualization capabilities/charts/technologies over all the presentation technologies, such as PowerPivot, Power View, Excel Charts, SSRS... ... View more

Leverage the Kinect for Windows (or in Xbox which should be a new possible device with Windows 10) for visualization, analysis, creation and navigation ... View more

Leverage the HoloLens technology for visualization, analysis, creation and navigation. ... View more