Will Thompson on 04 May 2017 01:27:49
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!
Administrator on 11 Apr 2023 17:09:51
while not exactly implemented as described, with the release of DQ/AS, the user story is covered and the feature is probably not going to be built separately.
Update 4/11/2023: composite models on Power BI Datasets and Analysis Services was released. https://powerbi.microsoft.com/en-us/blog/announcing-general-availability-for-composite-models-on-power-bi-datasets-and-analysis-services-models/
- Comments (36)
RE: Create calculated columns when using SSAS live connect
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.
RE: Create calculated columns when using SSAS live connect
It is possible to create measurements when live connected to tabular cube, but not to create new columns. This would be great to have!
RE: Create calculated columns when using SSAS live connect
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?
RE: Create calculated columns when using SSAS live connect
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.
RE: Create calculated columns when using SSAS live connect
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!
RE: Create calculated columns when using SSAS live connect
When is it finished? ;-)
RE: Create calculated columns when using SSAS live connect
Yes, it will be a good improvement.
RE: Create calculated columns when using SSAS live connect
The fact that we can't do this now is one of the main reason our end users are slow to warm up to the idea of using power bi. Please please please add this functionality.
RE: Create calculated columns when using SSAS live connect
The facility to create calculated columns in multidimensional mode is essential to any BI tool whether using Multidimensional or Tabular modes.
RE: Create calculated columns when using SSAS live connect
Yes we need this. Critical element to make Power BI useful