Skip to main content

Power BI

New

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

Vote (10) 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 (1)
Keng's profile image Profile Picture

6dba526f af3d-4d2a-afd2-094da3bce204 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.