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.

Hello Avi,
Can you send me email so i can connect w/ you w the team?
Thanks
Chuck
90 comments
-
Jez commented
We are about to hit 2020 - Backlog update appears to be Sept 2018... ?!! At least allow disconnected slicer tables...as an interim ?
-
Melissa van Etten commented
Graag zo spoedig mogelijk aanpassen
-
Anonymous commented
Goed idee!
-
Anonymous commented
Graag zo spoedig mogelijk
-
[Deleted User] commented
Super idee, z.s.m. mogelijk maken.
-
JJ commented
please also vote if you think we need also SAP BW as supported source for composite models https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/39080569-composite-models-when-connected-to-sap-business-wa
-
JJ commented
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
-
Markus Krenn commented
We need it for all live connections (i.e. SAP BW, Hana) as well
-
Will Hopkins commented
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
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
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
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.
-
Alexander Korn commented
any updates?
-
ryo commented
When will this feature be updated ?
Connect 2 SSAS with composite model, That is the big evolution conception of BI really ! -
jogo commented
Would be awesome to get some info when you wanna introduce it :-)
-
Josiah commented
This will greatly enhance the usability of Power BI dashboard-style capabilities
-
AndreasK commented
Is there any news? It's needed urgently
-
Sriram commented
I understand that it would be challenging to implement but will take Power BI to next level
-
Nate commented
Please implement. Like others as said, this is a much needed feature.
-
Anonymous commented
We need this feature asap