WillT
Community Admin
9 years agoStatus:
Completed
Create calculated columns when using SSAS live connect
In May 2017 Power BI Desktop started supporting creation of DAX measures when working in live connect mode to an external SSAS model: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/ Vote on this idea if you want support for calculated columns in this mode as well!
38 Comments
- Amy_HarrisNew MemberI agree with Dan English. Need this for both Multidimensional and Tabular. I'm excited to start working with calculated measures on top of a live SSAS connection.
- chris_klimm1New MemberYes, please! And could we get, Rename and New Group as well?
- denglishbi1New MemberWould this be for both Multidimensional and Tabular or just strictly Tabular? Just want to make sure I know what I am voting on;) Definitely want both.
- tartur88New MemberYes please!
- cdavidson1New MemberTo be able to use the new measure in the live connect mode would be fantastic
- pbiideas1New MemberThis would solve a lot of problems for us... including making hyperlinks within SSAS models work in a table/matrix.
- cdok1091
Advocate II
Yes, please!!!!! Calculated columns on live data (Power BI Service) is super critical!!!! - sandip_patel1New MemberYes it is helpful.
- bi98New MemberThis feature is really needed by my client, using Power BI online. They hold back-office transport data that will be stored in SSAS Cubes, and accessed securely by their customers, as a live connection. Admittedly it's my error for not doing due diligence, but if we'd known this functionality wasn't available we would probably not have gone the Power BI route. So yes please, on Desktop and Online!
- krazineuronsRegular VisitorThis would make life so easy and make PowerBi a differentiate PowerBI from the Competition. Here's a scenario it would help me with, i am trying to setup different visuals and we prefer using a cube that way we have a powerful machine processing the cube the way we want it. Then i come across suggestions on the forum on using a calculated column to achieve a scenario X in power Bi, guess what i have to do right now? Deploy a new model :(. With this i would be able to do it out of the box!
Recent ideas
Allow Excluding Specific Tables or Columns from Automatic Relationship Detection
Power BI automatically detects and creates relationships between tables when data is loaded. While this is useful, there are scenarios where certain tables or columns are intentionally designed to re...MohamedFowzan11 hour agoSuper UserNew4Views0likes0CommentsHave a DIRECT way to reach the *Transform Data Button* from any menu.
Hi. Currently (2026), in PowerBI you have to go click the HOME menu, than click the Transform Data button, each time you want to reach the Query editor menu. Please either create a dedicated button /...MOFabric2 hours agoRegular VisitorNew5Views0likes0CommentsShow clickable links to dependent objects, aka a usable lineage
I have say 12 reports connected to a semantic model which I have just changed so I need to check if anything has broken. This use to be easy, just click the semantic model to see dependents but this ...skiwii4 hours agoAdvocate INew5Views0likes0CommentsexecuteDaxQueries-like API call with effectiveUserName on SSO-enabled model with Service Principal
Please provide a way for a service principal to execute DAX - with an effective user name - against an SSO-enabled directlake semantic model and get per-user results that respect lakehouse OneLake Se...sean_cochran6 hours agoResolver INew4Views0likes0Comments