Power BI
CompletedComposite 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 18 Mar 2022 04:15:01
The preview is underway: DirectQuery for Power BI datasets and Azure Analysis Services (preview) | Microsoft Power BI Blog | Microsoft Power BI. Please try it and provide feedback.
- Comments (254)
- Merged Idea (7)
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!
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Sounds like it would be a helpful feature
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
When connecting to a live SSAS in Desktop, once you've connected "Get Data" and "Recent Sources" goes gray. Please allow for additional data sources to be added in after making a live connection to SSAS.