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
IS there any update on this feature or idea if MS is planning to add it or not?
RE: Create calculated measures on top of a live SSAS connection
This is a must-have feature. Increase the power of Power BI by adding this capability...please!
RE: Create calculated measures on top of a live SSAS connection
We Were Planning to Use POwer BI as a Reporting tool for Our Field Sales Team over an Already Builded SSAS Model in our Organization....
We realized that the user can not create Measures and Columns; which is a must have for Large Organizations... This tool is on Halt because of this.
Do you Guys have a Deadline / Target Date for this?
Are you guys working on it already?
RE: Create calculated measures on top of a live SSAS connection
I can't move a large number of reports from Excel to Power BI without this feature. Please!
RE: Create calculated measures on top of a live SSAS connection
Can you guys give us an update on this one? You can do it! Let's make it happen!
RE: Create calculated measures on top of a live SSAS connection
First step: Calculated Measures on top of a live query connection. Next step add mashup capabilities with other data sources and streams. This would be a killer feature. Of course security is complex, but you will make it! Cross fingers.
RE: Create calculated measures on top of a live SSAS connection
This is realy realy important !!
RE: Create calculated measures on top of a live SSAS connection
we need this feature on top of both - Tabular AND Multidimensional - like Excel does
RE: Create calculated measures on top of a live SSAS connection
I want to create a New Table in a report where the data is connected via a SQL Server Database using Direct Query.
Is this covered in this suggestion?
RE: Create calculated measures on top of a live SSAS connection
This is a very critical feature for Enterprises. I see this as well as a road blocker to convincing power BI with in organization