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.
Can you send me email so i can connect w/ you w the team?
Shane Glasheen commented
Definitely would add value for us since our SSAS cubes are developed per subject area and it's not feasible (nor desirable) to have to create a single giant model/cube to work around these limitations of Power BI.
until composite models are resolved for SQL Server Analysis Services I really can not use the product and have to resort back to Excel Power Pivots.
This would be hugely beneficial to our reporting.
Leonel Castellano commented
Want this so bad. Can I vote again?
Andreas Enstrom commented
Any update on this much needed feature?
@Microsoft: Please do something about this, as it is crucial for so many companies.
This would really be a game changer, at least for us. We have several models built for each functional area e.g. Sales, Financials, Expenses, Operations and would like to connect to several of these in a single report to show impact of one area over the other.
BUY HIGH QUALITY REAL/FAKE PASSPORTS,DRIVERS LICENSE(email@example.com),ID CARDS,Counterfeits Bank notes,TOEFL,IELTS,TOEIC,SSN,divorc
Manish Siwach commented
Composite model is very much needed in PBI Report Server.
Lamin Jobe commented
This is a crucial feature and must have!
Morten Fammé Hviid-Hansen commented
This is highly relevant and needed for us enterprise users.
As far as I know, Microsoft is working on this feature undercover.
Check this video starting from 44:00 Minutes ( Christian Wade with Jeffery Wang)
Composite model toghether with SSAS live connection would help us a lot to solve ad hoc requests properly and in a fast way.
Eagerly waiting for this feature. It will help us bridge the gap between performance and extendability. Hoping that this feature is part of the next release for Power BI.
Mithun Balamurugan commented
This should be the next big feature for Power BI. Definitely a must have feature!
Another vote for this. We have data sources that for one reason or another cannot be pulled into our tabular model but that users really want mashed up into their reports and dashboards.
I would also like this idea to work when connecting to live to tabular models. So it is possible to connect to multiple ssas in one desktop file in the same way as with excel.
I agree completely with this suggestion.
Please make sure this is done on the RS version of PB also. So many features not included in the PB RS version that are in the public release. Stop ignoring on prem customers.
Sean Earp commented
Ha... I just watched Avi's video and he said the exact thing I did, in a much more engaging way. Great video!