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
Any update on this? We're busy reviewing the different dashboarding solutions and the ETA on this will help us make the call.
Thanks
RE: Create calculated measures on top of a live SSAS connection
We're hoping to use Power BI rather than Tableau, as we're using the Microsoft BI stack for everything else, but this is a big limitation.
If you can produce this fast, or give a rough ETA, that would be great. We're using Tabular models, analyse in excel is not an option as we're an SaaS platform.
RE: Create calculated measures on top of a live SSAS connection
It is a shame to have so limited features
RE: Create calculated measures on top of a live SSAS connection
Any update on progress?
RE: Create calculated measures on top of a live SSAS connection
Your competitors are using not having this feature against you. Can you give us an update on the Multi Dimensional Cube portion?
RE: Create calculated measures on top of a live SSAS connection
That's a good news indeed because you're still very limited when you connect PowerBI to a SSAS source. Any ETA on the update for SSAS multidim - DirectQuery mode? Thanks
RE: Create calculated measures on top of a live SSAS connection
Multidimensional is the most important for us as well. We currently have to provide a Tableau offering that we could discontinue.
RE: Create calculated measures on top of a live SSAS connection
This is fantastic. We have multiple SSAS cubes that need % of total and other custom measure flexibility. Do we have an ETA on this?
RE: Create calculated measures on top of a live SSAS connection
A vendor told us that calculated measure against MD models is 2 to 3 years out. Tell me this isn't true :)
RE: Create calculated measures on top of a live SSAS connection
Great news! We really need the MD support, so I hope that comes out quickly after Tabular. Any timelines for this?