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
We're doing a shoot out between Deski and PowerBI, without this feature, we're not able to use PowerBI.
RE: Create calculated measures on top of a live SSAS connection
This was basic functionality in Proclarity, can't believe this is not available!
RE: Create calculated measures on top of a live SSAS connection
It feels like time for an update since 'Under Review' status change a few months ago
RE: Create calculated measures on top of a live SSAS connection
Following.....
RE: Create calculated measures on top of a live SSAS connection
This limitation is a total road block right now for our goal of moving to Power BI with our SSAS customers.
RE: Create calculated measures on top of a live SSAS connection
Any update on this ?
This would be really helpful for us as business wants it.
RE: Create calculated measures on top of a live SSAS connection
From my perspective the most important feature that must be added immediatly. We have a lot of users that are interested to build their Dashboards with Power BI on top of SSAS cubes and thez would like to be able to define their own calculations. Right now this painpoint limits the usage of PowerBI in our organization.
RE: Create calculated measures on top of a live SSAS connection
Any new information about this? This is really necessary!
RE: Create calculated measures on top of a live SSAS connection
This would be very useful. I would be able to use Power BI more often if it had this feature.
RE: Create calculated measures on top of a live SSAS connection
When is this must have feature coming to power BI? Custom calculation on top of the SSAS cubes are must have for prototyping as well as realizing Self Service BI.
Please bring this feature early!