When you need to process hundreds of tables in Integration Services, it becomes tedious and error prone, not to mention extraordinarily time-consuming. We need a way to generate ssis packages for hundreds of tables from a generic template, perhaps only pointing to the database from which the tables will be sourced and the destination database ... 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

Many of the metrics on our dashboards need explanation. What, for example, does 'Daily Active Users excluding Internals' mean? We d like to be able to hyperlink to our glossary. Hyperlinks would also allows to support scenario like users reporting bad figures, sending us feedback, etc. ... View more

Tables should have the ability to display data in the natural order. Example: We do most of our manipulation in SQL (rename headers something nice, order the data the way we want it, etc). Then PowerBI goes and sorts it alphabetically by the first column. ... View more

e.g. UserCountPercentile99 -> User Count Percentile 99 In Cosmos / SQL / etc are columns are things like 'UserCountPercentile99'. The title line in graphs with multiple of test look poor. (We can rename columns via Excel, but we don't always want Excel and we don't always want the extra work) ... View more

Refresh support for Cosmos streams or at least .tsv files hosted on Cosmos urls ... View more

Cosmos is getting popular within Microsoft and will be popular once it's available to outside world. Power BI should support it fully, not just Power Query in Excel. ... View more

Why is there no ability to copy charts/tables from Power BI so they can be pasted into OneNote, Excel, Outlook, or PowerPoint??? ... View more

When will scheduled refresh work for Excel/Power Query connected to a SQL database? We need this for automated dashboard updates. ... View more

It would be great to have data represented as a word cloud. For example, I want to enter employees' competencies and weight them. A word cloud is great for upper management and having it interactive like other graphs would blow C-level minds. ... View more

When using the web refresh with anonymous connection, the second part of the formula doesn't work. Need ability to use token as authentication method with other header information from Power Query ... View more

API to pull data and images from PowerBI: - get list of Reports, Dashboards - get data from Dataset (e.g., as CSV, JSON) - get data from Report - get image of visualization PowerBI has 3 types of objects: - Datasets. They contain pure data, just rows. - Reports. It's visualizations for data. Actual state of report can be pinned to dashboard. - Dashboard. Set of pinned visualizations. PowerBI API allows get list of Datasets and push data into them. Getting list of Reports is not supported. So request is for: API to pull data and images from PowerBI: - get list of Reports, Dashboards - get data from Dataset (e.g., as CSV, JSON) - get data from Report - get image of visualization e.g., for - get data from Dataset (e.g., as CSV, JSON) I tried to send HTTP GET to https://api.powerbi.com/beta/myorg/datasets/{dataset_id}/table/{table_name}/rows but server returned 404 error code. From http://stackoverflow.com/questions/30124663/power-bi-rest-api-import-data/30170158 ... View more

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

The actual Excel Import don't Support any Features from Excel like hidden rows and columns, it cant use comment fields and so on. ... View more

SSIS cant work at the Moment with Textfiles that has incomplete rows. ... View more

It would be handy to secure attributes in SSAS OLAP in a way that confidential attributes are only shown to a specific user group. Example: if you take customer-dimension in Adventure-Works attribute "birth date". (out of simplification) all user should be able to see all customers but only some users should be able to "see" birth-date. An allowed User should be able to show "birth date" as a propertie of costumer. if a restricted user opens the same report attribute "birth date" shouldn't be shown at all but still all other customer-related informations. ... View more

Updatable database snapshots - Allow sparse files to manage new writable snapshots - start with read only databases - it will allow to create one copy of core development db and various versions of qa/dev/reporting copies with minimum space to test large set of data for various teams. ... View more

Being able via an API / web address to trigger a source refresh – we have sources that could take 4 to 5 hours but sometime it can take more. Scheduling the refresh at a given time you may miss a refresh cycle / or refreshing the data every hour while the source is updated only once a day is using resources for nothing. Being able to trigger a refresh “automatically” at the end of the job process would allow to coordinate tasks (DB refresh, Cube refresh, Excel file refresh and then PowerBI refresh). ... 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