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)
Being able connect to multiple data sources including live connections to live SSAS cubes (both multi dimensional and tabular) is in my opinion one of the most critical features currently missing from PBI. In a large organization where data and insights are available in many SSAS cubes this features would be like having the "holy grail" to enable virtual integration without having to rebuild measures or creating complex and unwarranted physical data integration steps.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
It would be a helpful feature. Needs to be considerate for the next releases.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Kind of weird to lack such a basic feature.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
The days of trying to anticipate that you will be able to organize data for single connection have long passed - everybody wants/needs federated access to lots of disparate sources with single retrieval. 'Big Data' principles deal w/ it one way, but on smaller, internal scales we are still trying to do the same thing w/ data extracting and external (to the DB) storage locations. A big pain & one reason companies are willing to pay Oracle's expensive price tag.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Yes, a thousand times yes. This is important to us.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Very important feature. Needs to be considerate for the next releases.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
This is a significant limitation, we are currently trying to migrate from SAP Business Objects to the Microsoft platform. However, with Business Objects we can combine queries from multiple universes and then merge the data on dimensions that are the same. My understanding is SSAS is the closest thing Microsoft has to a semantic layer (universe)? In Power BI, you cannot query from multiple SSAS sources or any other data source for that matter once you've made a live connection to SSAS?
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
We organize our SSAS data sources into subject areas. One subject area per fact table/star schema. We need the ability to merge the data across multiple SSAS data sources as well as pull in third party data source e.g. published census data
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Very important feature. Need ability to combine multiple sources without having to import data.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
I didn't see your post before I made mine with the exact same idea. We need to be able to make a template and switch the data source so we can "plug and play" and not have to re-create the report each time for live connections!