Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    When will Power BI support custom mdx statement in live connection SSAS

    Vote (12) Share
    Keng's profile image

    Keng on 07 Jun 2016 19:06:55

    Recently we used live connection to SSAS (On-Premise) and needed to add or custom mdx statement. Could you please to add the feature?

    Comments (2)
    Keng's profile image Profile Picture

    steven milardovich on 24 Aug 2021 16:39:16

    RE: When will Power BI support custom mdx statement in live connection SSAS

    Agree this feature would be a HUGE improvement. Causing so much extra work and modeling to recreate measures which work just fine in MDX and consuming through Excel. Very common things like % of Total do not work in Power BI when built on OLAP with MDX.

    Keng's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:45:52

    RE: When will Power BI support custom mdx statement in live connection SSAS

    This is sooooooooooo needed... keep in mind that the "live" connection is the best option to avoid storing additional data in the power bi report, but having no MDX option in the "live" connection implies having to accept very very inefficient queries... I just tested a live connection adding a few dimensions and measures, and the memory of the server where the Cube is placed went sky rocket, without considering that the final query performance is quite bad.