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?
This would be great! Sometimes the tabular model might be focused on one aspect and we just need to integrate another piece of data for a specific report...this would enable us to kind of compartmentalize things.
For example there may be a 'Sales' tabular model for the entire organization, but for one portion sales are tied heavily to maybe the weather. That group may want to integrate weather data with their sales analysis...without this feature they either: A. have to make their own model to include the weather data or B. get the enterprise developers to include weather data (which possibly no one else will use) into the tabular model.
Rajaniesh Kaushikk commented
Any timelines for this feature
Rajaniesh Kaushikk commented
We are eagerly waiting for this feature
This was placed in the backlog in September. Any update on the planning for implementation? This is urgently needed for us and our users.
Should be available for Azure Analysis Services too!
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!