Power BI
Under ReviewComposite models when connected to AS models (PBI datasets and Azure Analysis Services)
Sander A. on 25 Jul 2018 14:39:12
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.
Administrator on 16 Aug 2020 02:15:40
This is being worked on! It's a long project but active development has started. Stay tuned for more information. Thanks for all the votes and support!
- Comments (222)
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
This would be such a nice feature!
Imagine letting users access the centralized model were all relations and measures are defined, and then let them add external data such as population to see correlation between sales and population in different cities.
Please add support for this ASAP! :)
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Would be nice if someone from the Power BI Team provides an update on this. Even an update that says this is just way too complicated so don't expect it anytime in the near future is fine so we can stop thinking about it and follow alternate paths.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
This is something that we would also love to see implemented. We're moving to start using SSAS and being able to blend that data in Power BI, or blend data from multiple cubes together is something we will really need.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Should be added. Very useful feature
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
'+2 to this. Not everything is just in one cube...
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
'+1 to Sreedhar's suggestion:
a) To combine multiple SSAS data sources.
Say, if we are combining from two different Sales (platform, product, area) cubes and present as one single place like dashboard.
b) To combine SSAS and other data sources.
Say, if we have Sales Cube and may want to have SQL (lookup, category) tables i.e., Having a model on top of a Cube data in Power BI.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Please, Waiting for this function, It is very useful
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Probably very complicated... But the possibility to enhance a centrally defined SSAS model would be lovely!! In the modeling section you could grey out ("read only") the parts of the SSAS model but allow additional relationships to it...
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
we need this function
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
please