Creating a live connection to SSAS MD or Tabular is working just fine. However, it would be very beneficial to have the ability to create new calculated measures (in MDX). Just like we can create our own calculated measures when writing an MDX query for a SSRS dataset.
Administrator on 04 May 2017 01:33:35
Hi everyone! I'm really excited to announce that you can now create calculated measures on top of a live SSAS connection! The measures are stored in your report definition and sent along with the queries to your model. You can read more information about that here https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/. We're planning support for quick measures in this mode soon, and also looking at expanding this further based on your feedback: - If you want calculated columns/tables you can vote here https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19140907-create-calculated-columns-when-using-ssas-live-con - If you want support over SSAS Multidimensional, vote here https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19140997-calculated-measures-when-live-connected-to-mdx-cub Thanks everyone!
- Comments (145)
RE: Create calculated measures on top of a live SSAS connection
I cant use Report level measures for live connections to Analysis Services
RE: Create calculated measures on top of a live SSAS connection
I agree with the previous comments this isn't complete from our perspective. Multi-dimensional support is needed. A big pushback from our key user base to wider adoption is this support
RE: Create calculated measures on top of a live SSAS connection
Will and Chuck - We MUST HAVE MULTI-DIMENSIONAL SUPPORT for new measures, calculations AND hierarchies. Please advise when you plan to release, if ever. Please advise when this will be available as we have multiple customers that need it yesterday to support their PBI deployments. Thanks much!
RE: Create calculated measures on top of a live SSAS connection
Agree, I was hopeful with this release that it would support multidimensional models. I actually couldn't figure out why it wasn't working until I came back to this thread to see these comments.
Will, could you comment on when multidimensional models will be supported?
RE: Create calculated measures on top of a live SSAS connection
HI Will (MS) :
I am sorry but this is simply not ok. It is seriously disappointing how Microsoft is managing this. The feature clearly stated BOTH Multidimensional AND Tabular. It is not fair with the community to simply deliver 50% , and close as completed! . Many people that has been voting on Multidimensional will not vote on the new idea.
RE: Create calculated measures on top of a live SSAS connection
Hi Will
I'm totally Agree with previous comments, this is not complete. Please correct the status of the idea and tell us when will it be posible for Multidimensional SSAS models.
Thank you.
RE: Create calculated measures on top of a live SSAS connection
Brilliant news, thank you! This seems to work exactly the way I hoped. Looking forward to also seeing calculated columns.
RE: Create calculated measures on top of a live SSAS connection
Agree with previous comment, this is not complete.
As far as I know, we are talking SSAS here right?
RE: Create calculated measures on top of a live SSAS connection
The idea clearly is about BOTH multidimensional and tabular. This is 1/2 completed.
RE: Create calculated measures on top of a live SSAS connection
Excellent. Thanks to the PBI team for that great functionality!!!