Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

WillT

Create calculated columns when using SSAS live connect

Submitted by Community Admin on ‎05-03-2017 06:27 PM
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!
Status: Completed
See more ideas labeled with:
38 Comments (38 New)
Comments
Amy_Harris
New Member
‎07-05-2020 03:47 PM
I 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_klimm1
New Member
‎07-05-2020 03:47 PM
Yes, please! And could we get, Rename and New Group as well?
denglishbi1
New Member
‎07-05-2020 03:47 PM
Would 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.
tartur88
New Member
‎07-05-2020 03:47 PM
Yes please!
cdavidson1
New Member
‎07-05-2020 03:48 PM
To be able to use the new measure in the live connect mode would be fantastic
pbiideas1
New Member
‎07-05-2020 03:48 PM
This would solve a lot of problems for us... including making hyperlinks within SSAS models work in a table/matrix.
cdok1091
Advocate II
Advocate II
‎07-05-2020 03:48 PM
Yes, please!!!!! Calculated columns on live data (Power BI Service) is super critical!!!!
sandip_patel1
New Member
‎07-05-2020 03:48 PM
Yes it is helpful.
bi98
New Member
‎07-05-2020 03:49 PM
This 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!
krazineurons
Regular Visitor
‎07-05-2020 03:49 PM
This 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!