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

    Power BI Ideas Admin on 05 Jul 2020 22:48:15

    RE: Create calculated columns when using SSAS live connect

    This would solve a lot of problems for us... including making hyperlinks within SSAS models work in a table/matrix.

    Will Thompson's profile image Profile Picture

    Chuck Dokmo on 05 Jul 2020 22:48:11

    RE: Create calculated columns when using SSAS live connect

    Yes, please!!!!! Calculated columns on live data (Power BI Service) is super critical!!!!

    Will Thompson's profile image Profile Picture

    Artur Tolstenco on 05 Jul 2020 22:47:59

    RE: Create calculated columns when using SSAS live connect

    Yes please!

    Will Thompson's profile image Profile Picture

    Chris Klimm on 05 Jul 2020 22:47:54

    RE: Create calculated columns when using SSAS live connect

    Yes, please! And could we get, Rename and New Group as well?

    Will Thompson's profile image Profile Picture

    Amy Harris on 05 Jul 2020 22:47:47

    RE: Create calculated columns when using SSAS live connect

    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.

    Will Thompson's profile image Profile Picture

    Dan English on 05 Jul 2020 22:47:37

    RE: Create calculated columns when using SSAS live connect

    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.