We need a native connection to Analysis Services for Java similar to the SQL relational database using JDBC. On the C#, we have ADOMD.NET. We need the equivalent for other enterprise programming languages with Java being the biggest outside C#. Requiring our customer to setup IIS with the data pump dll is an extra support overhead. We also pull a lot more data across the network due to the SOAP request.
... View more
Currently many teams manage SSAS role-based security using service accounts. However, service accounts are incompatible with O365 and the new two-factor authentication introduced by MSFT. Need a workaround to use role-based security with the new PowerBI Service.
... View more
It would be great to query the Power BI Q&A via REST interface. The output could be in JSON format and can then be used in customer apps, custom dashboards/charts. Maybe it's also possible to deliver the reports/dashboards directly via the response?
... View more
In SSAS FE is always a bottle neck, hope we can make FE to support multi-thread. And improve MDX Rank function to dynamically work with more than one dimensions.
... View more
I encounter lots of clients that has to export the result of Power Query work out to regions or channels in their respective companies. This is painful as filters in the table has to selected and each filtered set saved, then mail. The only way currently is through a very painful trial and error homegrown VBA style app. Not all of our clients can or want to sign up in order to share Power Query queries. They just want to send their operational reports asap
... View more
A fixed point in time, once a day... is often not adequate. Calling an API to refresh Power Pivot model and reports connected to it... would be awesome. And it should work with Power Query connected models, if you love me.
... View more
Please add a search capability in the field list. This is extremely important while trying to browse through complex data models and trying to find the field that you want
... View more
When I publish the query to the cloud data catalog, I want it can be exposed as an OData feed so that I can use other tool to easily consume it.
... View more
The Power View should have a web part control to display external content inside a Power View dashboard. For example, you can embed a reporting service report inside the web part control. The concept is similar to SharePoint page viewer and Tableau web part.
... View more
Currently if I need to alter a dataset it requires deleting it and recreating it completely. It would be nice to be able to alter datasets as needed (e.g. adding or removing tables, columns, etc.).
... View more
Right now the API allows us to create basic schemas. It'd be nice to be able to define more complex data models through the API but most importantly relationships.
... View more
Submitted on02-17-201508:23 AMSubmitted bymourad1on02-17-201508:23 AM
The new Data VIsualization as Power View can be directly used by end user to create their own reports. Also, We can propose some predifine report. The development tool is Visual Studio. It's enable to manage the source code and to facilitate the deployment on different environment.
... View more
Submitted on02-17-201508:37 AMSubmitted bymourad1on02-17-201508:37 AM
In Tabular SSAS model relationship is limited. Can we have the same or equivalent capacity for relationship on SSAS Tabular and Multidimensional. - Enable relationship on different granularities. - Enable multiple relationship. - Allow, Many to Many / One to Many / Many to One...
... View more
Can we open up Power BI to allow other creative thinkers out there to create new visualizations that can be posted on Power BI dashboard? As long as they have certain parameters (Name, chart types (visualization types), input data, scale, whatever, etc.) they can call API that can draw that visual to be displayed in Power BI. This opens up creative ways to display data and allows Power BI to be extensive and flexible.
... View more
Make analytics drag and drop e.g. - drag and drop a trend line onto to the board. This should be interactive as well - show outliers as a different colour, or the ability to exclude them. - show a little panel that gives you the descriptive statistics, and does a chart call out to show the dispersion (for example).
... View more
MOre third party data sources e.g. Google Analytics, Tableau TDE Files. Make it more specific that OData so that the data source is really drawn out.
... View more
A SSRS grid control (possibly with a pre-specified number of columns) that sources data from SSAS OLAP, is aggregate-aware and can accept mostly any MDX queries thrown at it (without any result set flattening).
... View more