How can we improve Power BI?

Create calculated columns when using SSAS live connect

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!

681 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdminWill Thompson (Product Manager, Power BI, Microsoft Power BI) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    27 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • William commented  ·   ·  Flag as inappropriate

        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 ?

      • Jenny Fahlstedt commented  ·   ·  Flag as inappropriate

        It is possible to create measurements when live connected to tabular cube, but not to create new columns. This would be great to have!

      • William commented  ·   ·  Flag as inappropriate

        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.

      • Chris Klimm commented  ·   ·  Flag as inappropriate

        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?

      • DamienK commented  ·   ·  Flag as inappropriate

        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.

      • Danaraj commented  ·   ·  Flag as inappropriate

        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!

      • Maria Megnia commented  ·   ·  Flag as inappropriate

        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.

      • Nicky Hopkins commented  ·   ·  Flag as inappropriate

        The facility to create calculated columns in multidimensional mode is essential to any BI tool whether using Multidimensional or Tabular modes.

      • Kawabata Yoshihiro commented  ·   ·  Flag as inappropriate

        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.

      • Erik Areskog Elming commented  ·   ·  Flag as inappropriate

        This is definitely needed for both Tabular and Multidimensional. The lack of this is one of the key arguments for investing in other solutions than PowerBI.

      • Tamsin Harriman commented  ·   ·  Flag as inappropriate

        I would also like to be able to combine data sources when one of them is a live connection to SSAS. For example, combine fields from an Excel spreadsheet with a related SSAS data source. There is probably a separate suggestion out there already for this but I haven't found it yet... If anyone can point me to one please do so I can vote on it rather than duplicating!

      • Dylan Morgan commented  ·   ·  Flag as inappropriate

        This is not a practical request. A DAX Measure is metadata, and can be passed in at query time. This allows you to creat DAX measures in Power BI and execute them in Analysis Services. A calculated column is a materialized data element evaluated at model process time. Adding the ability for users to add these in Power BI is dangerous because you are essentially adding model development. Calculated columns are generally An anti pattern in enterprise models, because they consume memory and logic that uses them is almost always better placed in ETL or a measure definition.

        Do NOT do this.

      • Sairam S Simha commented  ·   ·  Flag as inappropriate

        Definitely a requirement. Part of a leading manufacturing/automation organization, being agile on our feet with data is extremely important.

        +100 from my end.

      • Waheed commented  ·   ·  Flag as inappropriate

        Yes we need it and will surely do much help rather going back to cubes.

        Thanks.

      • Nigel Frost commented  ·   ·  Flag as inappropriate

        This feature is really needed by my client, using Power BI online. They hold back-office transport data that will be stored in SSAS Cubes, and accessed securely by their customers, as a live connection. Admittedly it's my error for not doing due diligence, but if we'd known this functionality wasn't available we would probably not have gone the Power BI route. So yes please, on Desktop and Online!

      • Anirudh Goel commented  ·   ·  Flag as inappropriate

        This would make life so easy and make PowerBi a differentiate PowerBI from the Competition. Here's a scenario it would help me with, i am trying to setup different visuals and we prefer using a cube that way we have a powerful machine processing the cube the way we want it. Then i come across suggestions on the forum on using a calculated column to achieve a scenario X in power Bi, guess what i have to do right now? Deploy a new model :(. With this i would be able to do it out of the box!

      ← Previous 1

      Feedback and Knowledge Base

      Ready to get started?

      Try new features of Power BI today by signing up and learn more about our powerful suite of apps.