How can we improve Power BI?

Composite models when connected to SQL Server Analysis Services Tabular (SSAS)

We really love the new feature of 'Composite Models' in the Power BI July 2018 update! This enables us to join custom lists with DirectQuery sources.

It would also be beneficial if this would also work when connected to SSAS Tabular in DirectQuery.
This would stronlgy improve the enterprise features of Power BI.

214 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

    Sander A. shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    13 comments

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

        The feature would definitely supercharge Power BI as external data could be easily combined with central data warehouses running SSAS tabular...

        I would love to see this feature in upcoming releases.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Our local gov dept needs this please please please. Live connection to Power BI datasets.

      • Abi Sivasubramanian commented  ·   ·  Flag as inappropriate

        Yes, I want this too...I want business users to have that flexibility!We cannot import everything into the cube and if someone wants any adhoc reports integrating excel data and cube data...It adds more value and encourages them to use Power BI. I agree with Avi...it's fact!

      • Anonymous commented  ·   ·  Flag as inappropriate

        Connect live to my IT SQL 2016 SSAS Tabular cube with composite modelling is a must and will not only save time and money but will deliver faster results for my key uses. It has to be a must have

      • Avi Singh commented  ·   ·  Flag as inappropriate

        Josh BI UK. I would beg to differ. Is Business Users need to combine other data, they are going to do it. Allowing them to do this in Power BI gives the Admins some opportunity to monitor that (possibly using Telemetry in Power BI.com to check which Models have been deployed). Otherwise, users would do this but in Excel or Power Point or some other way. It's impossible to stop that. you know what they say...if you can't beat them... :-)

        Power On! / Avi

      • Josh_BI_UK commented  ·   ·  Flag as inappropriate

        I actually prefer the fact that if a user connects to a SSAS Tabular model, they can't add any other sources. If they could, it would defeat the purpose of a controlled model?

      • Brandy Olsen commented  ·   ·  Flag as inappropriate

        I LOVE the composite models feature! Please release this for full use soon! And as mentioned above....Please add the ability to use composite on all the different data sources including SSRS! The more the better!

      • ryo commented  ·   ·  Flag as inappropriate

        yes it's a good idea for SSAS tabular it's a principal feature for Business Intelligence. composite multiple SSAS connections for cube and link by slice time for example. If there is this fonction Power bi will the best BI feature.

      • Tibo commented  ·   ·  Flag as inappropriate

        +1

        I was so disappointed when I saw the SSAS listed as a limitation of that new feature...

      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.