How can we improve Power BI?

← Power BI Ideas

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.

1,340 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

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

90 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Jez commented  ·   ·  Flag as inappropriate

    We are about to hit 2020 - Backlog update appears to be Sept 2018... ?!! At least allow disconnected slicer tables...as an interim ?

  • JJ commented  ·   ·  Flag as inappropriate

    missing "composite model" support makes external SSAS Tabular the worst datasource to use with PowerBI :( Is there really NO option to add additional datatables to an SSAS Tabular "Live" Conncection? With SAP HANA/BW and directquery this can be done , also sap cloud analytics can add additional data in live mode

  • Will Hopkins commented  ·   ·  Flag as inappropriate

    One intermediate step would be to allow the creation or import of standalone tables for use in slicers. These tables do not need to be connected in the data model to the underlying SSAS data.

    These slicers can then be used to select among measures in either the underlying SSAS model or report level measures. A good example is a simple slicer to select between units displayed in lbs or kg.

  • Will Hopkins commented  ·   ·  Flag as inappropriate

    One intermediate step would be to allow the creation or import of standalone table for use in slicers. These slicers can then be used to select among measures in either the underlying tabular model or report level measures. I good example is a simple slicer to select between units displayed in lbs or kg.

  • jordan commented  ·   ·  Flag as inappropriate

    Definitely need this feature to complete enterprise bi offering. Hot/warm/cold tables, with hot being direct query, would save so much mid-day processing.

  • Mitesh Bhadani commented  ·   ·  Flag as inappropriate

    It would be great if you could provide at least a timeline for the feature, It will be a game changing for the BI platform and easily transform any domain by connecting history to present.

  • ryo commented  ·   ·  Flag as inappropriate

    When will this feature be updated ?
    Connect 2 SSAS with composite model, That is the big evolution conception of BI really !

  • jogo commented  ·   ·  Flag as inappropriate

    Would be awesome to get some info when you wanna introduce it :-)

  • Josiah commented  ·   ·  Flag as inappropriate

    This will greatly enhance the usability of Power BI dashboard-style capabilities

  • Sriram commented  ·   ·  Flag as inappropriate

    I understand that it would be challenging to implement but will take Power BI to next level

  • Nate commented  ·   ·  Flag as inappropriate

    Please implement. Like others as said, this is a much needed feature.

← Previous 1 3 4 5

Power BI Ideas: Desktop

Categories

Feedback and Knowledge Base

(thinking…)

Ready to get started?

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