Being able to drag and drop members on to the rows and columns, as well as filters and sub-cube filters was so much more useful when checking the validity of a cube I just built.
... View more
Integrate both Tabular and Multidimensional into a true semantic layer and allow mixing of both forms of SSAS. Allow developers to utilise either MDX or DAX.
... View more
Submitted on03-03-201510:17 AMSubmitted byfbcideas_migusron03-03-201510:17 AM
We need relationship support between tables created programmatically. currently all data has to be denormalized and kept in a single table
... View more
Ability to have parity with Excel functions of copy past within a workbook * copy a PV worksheet into another worksheet * Ability move a worksheet to another location in workbook. * Scenario for copying may be that you would want to copy an existing PV into another worksheet as a starting point for building out a new visualization * Scenario for moving the worksheet with the workbook would be to enable simple re-order
... View more
Internally many MSFT teams use COSMOS as a data source. Import "From COSMOS cluster" is currently in beta for Power Query and has been working great for producing telemetry reports. Auto-refresh on Power BI sites for COSMOS linked spreadsheets is currently not supported. Our team (DOCS) would love to have this feature supported to save us many hours of manual refreshes.
... View more
Centralized management tools for subscriptions for SSRS reports. Running in SP integrated mode we need a way to see in the SP subscription list something unique to visually identify subscriptions. Something as simple as displaying a comment or allowing the subscriptions "manager" to enter a name/title for the subscription. We also need a consolidated view/report to see all the subscriptions with the parameters and schedule selected as well as the user email address would be helpful.
... View more
Define Parameter pane placement. Allow Parameter pane placement at the top, right, left, bottom. Allow parameter pane to default to visible or hidden.
... View more
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
Allow Charts to switch rows to columns or vice versa at design time to display the data on the axis that you want. Similar functionality exists in excel.
... View more
Retain parameter focus with a large parameter list. Focus goes back to the top forcing users to scroll back down to finish parameter selection.
... 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