Skip to main content

    Power BI

    Needs Votes

    Create calculated columns when using SSAS live connect

    Vote (914) 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!

    Comments (35)
    Will Thompson's profile image Profile Picture

    d244623b b892-4bae-a59b-7a3e66441109 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

    3c56e5be 81c7-4af6-83c9-bcd1556ddbe2 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

    74fe6afa 0271-4b5e-b9fc-b32ae7b28d65 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

    5c9f8677 532e-4275-856b-ad204f895260 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

    696ae8f1 3125-4641-9363-21a6fcfb7807 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

    de836b5c 8928-454b-8fa0-f6793d959fa5 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

    5943fed5 d9c4-4b41-b5ff-c81ac3e87d7a 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

    24381326 6b73-415b-bbbc-dc66fcda1880 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

    53e8c8dc dd0d-4a16-9067-1c63c9bc4e49 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 ?

    Will Thompson's profile image Profile Picture

    53e8c8dc dd0d-4a16-9067-1c63c9bc4e49 on 05 Jul 2020 23:24:20

    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.