How can we improve Power BI?

Calculated measures when live connected to MDX cubes

In May 2017 Power BI Desktop started supporting creation of DAX measures when working in live connect mode to an external SSAS model: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/

Vote on this idea if you want support for calculated measures against multidimensional models too.

276 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Will ThompsonAdminWill Thompson (Product Manager, Power BI, Microsoft Power BI) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    30 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Anirudh GoelAnirudh Goel commented  ·   ·  Flag as inappropriate

        Not every user of SSAS has a machine with beefy RAM thus invalidating using tabular models. By not offering Multidimensional support you are yourself discouraging people from using a Microsoft Tech, why so? Make it at parity!

      • TrinathTrinath commented  ·   ·  Flag as inappropriate

        Please dont say that, this has to go Planned--->Started-->Wait for an year--->Completed :O

      • Anonymous commented  ·   ·  Flag as inappropriate

        Always wondered why it wasn't included in the first place...
        Would love to have this option!

      • Ludwig CoosemansLudwig Coosemans commented  ·   ·  Flag as inappropriate

        This was a well-appreciated feature in DataZen which we were using when Microsoft acquired it. MS then promised to integrate DataZen into their own platform (now called Power BI), so it should only be a matter of time. Hopefully not for long anymore because many of our users have already started talking to us about Qlikview: they want to read the data warehouse (the data base!) in order to make their own reports, while all the value is already in the MD Cubes...

      • Maarten de HaasMaarten de Haas commented  ·   ·  Flag as inappropriate

        We invested a lot of time and effort in creating SSAS-MD cubes. These cubes are widely use in the organization. One of the key drivers for choosing PowerBI as our standard visualization tool was leverage our current installed base of MD-Cubes.

        Not being able to add simple calculated measures (delta's, index or ratio's). Forces our users to flatten our cubes (performance and consistency risks ) or move to export in excel. This creates a security risk.

        Please add support for calculated measures against multidimensional models ASAP!!

      • Krzysztof ZajączkowskiKrzysztof Zajączkowski commented  ·   ·  Flag as inappropriate

        I was also thinking that this will be fixed for multidimensional in the May update. It's a shame that despite the old thread already got 1,227 votes, we now need to vote again for MD.

        I think that most users were voting for multidimensional in the first place :).

      • Anonymous commented  ·   ·  Flag as inappropriate

        As others have mentioned, I think we all though multidimensional models would be supported based on the other idea thread...disappointing that we have to start a new thread to get this feature.

      • Todd GilmoreTodd Gilmore commented  ·   ·  Flag as inappropriate

        Fortune 200 company with many MD models in place. It's critical that MS enables this functionality so users can be empowered to create their own measures on the fly.

      • PeppePeppe commented  ·   ·  Flag as inappropriate

        Definitely a must-have to enable us switching to PowerBI.

        Disappointed to not see this functionality released along with DAX custom calculations. Would really appreciate to see MS supporting his MD community, Tabular is not fully ready yet to enable a transition from MD -> Tabular....

      • Andrejs GordijenkoAndrejs Gordijenko commented  ·   ·  Flag as inappropriate

        Lack of MD support is indeed a major holdup for several of our clients. They would love to migrate to Power BI, but now we have to "reinvent the wheel" to implement their requirements, instead of just switching to PowerBI

      • Anonymous commented  ·   ·  Flag as inappropriate

        The absence of calculated measures against live connected multidimensional cubes is major reason why we can't migrate to Power BI, and it's a major disappointment that the original idea was not implemented as described.

      • Michael HenryMichael Henry commented  ·   ·  Flag as inappropriate

        Given that our current and major investment with SSAS resides in MD its dissapointing that creating calculated measures against these types of cubes is a let down. I get that you're trying to push tabular but the trying to get powerbi pushed through industry is tough if we are also required to migrate all existing SSAS tools to tabular. Won't fly in my organization. PLEASE add calculated measures for SSAS MD and we will move over the PowerBI

      • Anonymous commented  ·   ·  Flag as inappropriate

        My original vote was also for SSAS MD support, we did not need the tabular. Agree with everyone the fact this was not included is disappointing

      • AdamPAdamP commented  ·   ·  Flag as inappropriate

        As per other comments, my vote originally was for SSAS MD support. We need this urgently.

      • JeleJele commented  ·   ·  Flag as inappropriate

        In line with other comments: the votes from the previous idea should be carried over to this one. We should not start back from zero. Or please reopen the previous one!

        Also please can you confirm that this idea is already underway as this was assumed in the previous idea?

      ← Previous 1

      Feedback and Knowledge Base

      Ready to get started?

      Try new features of Power BI today by signing up and learn more about our powerful suite of apps.