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
Much needed !
RE: Create calculated measures on top of a live SSAS connection
Big disappointment this doesn't work!
RE: Create calculated measures on top of a live SSAS connection
In order for us to start using Power BI as an enterprise reporting tool, we need analysts to be able to do modeling with Direct Query. Currently, we can either do modeling in Power BI with imported data, or have developers do modeling in SSAS with live data. Both ways are not practical when you have too much data to import, and reporting needs changing too fast for developers to handle.
RE: Create calculated measures on top of a live SSAS connection
This is the dagger that is missing to move everyone away from other tools into Power BI
RE: Create calculated measures on top of a live SSAS connection
Really needed
RE: Create calculated measures on top of a live SSAS connection
Really needed. When doing reports with Excel services (or what ever) I can create measures with MDX. Simply add that thing to power BI for starters...
RE: Create calculated measures on top of a live SSAS connection
See also https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10299933-new-calculated-fields-against-ssas-tabular
RE: Create calculated measures on top of a live SSAS connection
See also https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13417497-data-modelling-when-connecting-to-ssas-tabular
RE: Create calculated measures on top of a live SSAS connection
please add this feature
RE: Create calculated measures on top of a live SSAS connection
Very good one. I need this as well. We are considering using Tableau because we need this feature for end users to be able to create their own calculations and easy developers job.