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

    a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:24:20

    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!

    Will Thompson's profile image Profile Picture

    987e92c5 31f4-47d9-b2b5-9b4fd9d97a96 on 05 Jul 2020 23:23:05

    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?

    Will Thompson's profile image Profile Picture

    d5c46788 0541-425c-907d-a096a02fa483 on 05 Jul 2020 23:22:14

    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.

    Will Thompson's profile image Profile Picture

    a7babe40 b169-4ce3-aaa2-71f3e3e58fd1 on 05 Jul 2020 23:20:56

    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!

    Will Thompson's profile image Profile Picture

    ffc1696f 0fca-4a2b-81e3-b66a12c9fa71 on 05 Jul 2020 23:17:30

    RE: Create calculated columns when using SSAS live connect

    When is it finished? ;-)

    Will Thompson's profile image Profile Picture

    c99112a7 6e64-4af3-a586-d800855dc953 on 05 Jul 2020 23:14:25

    RE: Create calculated columns when using SSAS live connect

    Yes, it will be a good improvement.

    Will Thompson's profile image Profile Picture

    ccb7dc7e 829f-4a66-a991-a429d53bb450 on 05 Jul 2020 23:14:09

    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.

    Will Thompson's profile image Profile Picture

    fb11106f d339-4324-a899-74b760797568 on 05 Jul 2020 23:13:06

    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.

    Will Thompson's profile image Profile Picture

    2854a129 6f38-4f29-9172-052c965c03a9 on 05 Jul 2020 23:09:38

    RE: Create calculated columns when using SSAS live connect

    Yes we need this. Critical element to make Power BI useful

    Will Thompson's profile image Profile Picture

    d0aca558 5e84-498a-9cd8-6d63f1fe0aea on 05 Jul 2020 23:01:34

    RE: Create calculated columns when using SSAS live connect

    Yes, me too.
    I want to adding calculated columns to reports which connecting Power BI Services dataset.
    For adding date columns from date/time column,
    For grouping 1-5, 6-10, 11-15, ... value columns from 1,2,3,4,5, ... columns.

    I like the feature to adding measures to reports which connecting Power BI Services.
    So, I hope the feature to adding calculated columns, too.