Skip to main content
Microsoft Idea

    Power BI

    Completed

    Create calculated columns when using SSAS live connect

    Vote (1010) Share
    Will Thompson's profile image

    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)
    Will Thompson's profile image Profile Picture

    Martin Kanarbik on 01 Dec 2021 08:38:13

    RE: Create calculated columns when using SSAS live connect

    This would be a game changer!

    Will Thompson's profile image Profile Picture

    Priyanka Power BI User on 10 Jul 2020 17:22:29

    RE: Create calculated columns when using SSAS live connect

    ANy update on this ?

    Will Thompson's profile image Profile Picture

    Jonathan SunSolutions on 06 Jul 2020 00:13:27

    RE: Create calculated columns when using SSAS live connect

    Any update?

    Will Thompson's profile image Profile Picture

    Sedat Power BI User on 06 Jul 2020 00:13:26

    RE: Create calculated columns when using SSAS live connect

    Still needed...

    Will Thompson's profile image Profile Picture

    Manoj on 06 Jul 2020 00:10:46

    RE: Create calculated columns when using SSAS live connect

    Really in need of creating calculated columns when connected to SSAS Live from PBI Desktop. In our org, to deploy SSAS changes, we need huge process in place. Only PBI changes is in hands of power users. Giving this contol will be a huge advantage for many users.

    Will Thompson's profile image Profile Picture

    Roy Sleight on 06 Jul 2020 00:01:49

    RE: Create calculated columns when using SSAS live connect

    Any updates on this?

    Will Thompson's profile image Profile Picture

    Kshitiz on 05 Jul 2020 23:57:27

    RE: Create calculated columns when using SSAS live connect

    Enabling Calculated Columns to be created during live connection will be a really good feature to add in.

    Will Thompson's profile image Profile Picture

    Digbijayee (DJ) on 05 Jul 2020 23:33:37

    RE: Create calculated columns when using SSAS live connect

    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 .

    Will Thompson's profile image Profile Picture

    Filip Bouckaert on 05 Jul 2020 23:26:20

    RE: Create calculated columns when using SSAS live connect

    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 ?

    Will Thompson's profile image Profile Picture

    William on 05 Jul 2020 23:24:26

    RE: Create calculated columns when using SSAS live connect

    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 ?