on 02 Feb 2016 21:57:09
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
Power BI should support sets and actions. This will make Power BI really powerful.
RE: Create calculated measures on top of a live SSAS connection
As everyone said, this feature is critical to any self-service product.
RE: Create calculated measures on top of a live SSAS connection
This will make SSAS & Power BI a true self-service hybrid solution.
RE: Create calculated measures on top of a live SSAS connection
Critical for KPI adjustments and goals; Any feedback on implementing this feature?
RE: Create calculated measures on top of a live SSAS connection
This is an absolute killer feature we MUST have to let customers leverage their SSAS investments!
RE: Create calculated measures on top of a live SSAS connection
Need to have it if we should consider using PowerBI in the future
RE: Create calculated measures on top of a live SSAS connection
Can we get an update on this please? This is a must have feature as the import mode can refresh only 8 times a day.
RE: Create calculated measures on top of a live SSAS connection
Can we get an update on this? This has to happen. Such a basic feature that has been left out for far too long.
RE: Create calculated measures on top of a live SSAS connection
Team, its been ages since any update from the admin. When is this going to be available!!!????
RE: Create calculated measures on top of a live SSAS connection
It would be great to have this..
For large data sets we use Tabular and MD cubes. And when we cant create any measures then its difficult to use this in large environments.
We dont have incremental update as yet, so only option is use direct query .... that too with these limitations its makes life a bit tough and product hard to sell !!!