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
Doskamp
Advocate I
Advocate I
‎07-05-2020 04:17 PM
When is it finished? 😉
Danaraj
New Member
‎07-05-2020 04:20 PM
Definitely a needed requirement to enhance the model - usually 80-20 rule applies when the business users will try to enhance the model with their own data, and they will need the keys to do so!
DamienK
Advocate I
Advocate I
‎07-05-2020 04:22 PM
I found many other topics that ask the ability to create measures in live connection. It is too bad that all votes are not regrouped in only one idea. In total we have approximately 2000 votes ! This feature is very important for me.
chris_klimm1
New Member
‎07-05-2020 04:23 PM
Will, any update on this? It's a needed feature and with DAX measures already supported I'd think creating DAX calculated columns would be fairly easy to add?
pbiideas1
New Member
‎07-05-2020 04:24 PM
It is possible to create measurements when live connected to tabular cube, but not to create new columns. This would be great to have!
william_wy_lee
New Member
‎07-05-2020 04:24 PM
I am using Power BI version 2.58 and using SSAS live connection but new measure button was no enabled, I can't use it. And I also go to option to enable also new feature, seems no improvement. Any other setting / patch / license (I'm using Pro) needs ?
william_wy_lee
New Member
‎07-05-2020 04:24 PM
Hi Will, my Desktop BI version is 2.58, think it should allow create new column / measure in Live connection environment. However, I found that the feature was still dim, is there any video or procedure to follow to show me how to enable it. Thanks.
filip_bouckaert
New Member
‎07-05-2020 04:26 PM
I'm using the august version of Power BI Desktop and need to be able to add calculated measures on top of a live SSAS multidimensional connection. When will this be available ?
digbijayee_jena
New Member
‎07-05-2020 04:33 PM
yes create calculated column , Hierarchy and DAX Calculated Table will be very useful for Power Bi so that all can be created in Reporting Power BI Layer instead of doing same in Tabular Model with Live connection .
bajrakb
New Member
‎07-05-2020 04:57 PM
Enabling Calculated Columns to be created during live connection will be a really good feature to add in.