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?
I agree that this a much needed feature if Power BI wants to be scalable and managable. However I can see why it would not be easy, as part of the attraction with Analysis services live query is that the data and the security model is hosted on the analysis server, not Power BI service. Multiple models hosted on the same analysis services server would be relatively "easy", but even then conflicting roles needs to be resolved. Adding connections from other sources into the Power BI service as well, would require the security model to be on the service platform. I acctually would welcome that move - a Power BI service integration layer with tenant level security models, but without the need to import that data hosted on live/direct query sources (Please don't ask how that would work :) I guess the model would have to be pushed to the sources).
I urge you to consider implementing this feature asap. Without this we are forced to govern all sorts of non-sustainable workaround solutions even for the most simple scenarios.
Jonas Halldén commented
We have colleagues who feel forced to move to Tableau because of only this issue. (Oh no!) We need this in Power BI badly! Thanks!
Game changing feature. Do it!
Yves Haenen commented
I think customization through "Composite Models" with SSAS tabular live connection could give a boost to our report.
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!