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