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)
One intermediate step would be to allow the creation or import of standalone tables for use in slicers. These tables do not need to be connected in the data model to the underlying SSAS data.
These slicers can then be used to select among measures in either the underlying SSAS model or report level measures. A good example is a simple slicer to select between units displayed in lbs or kg.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Definitely need this feature to complete enterprise bi offering. Hot/warm/cold tables, with hot being direct query, would save so much mid-day processing.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
This is an absolute must to enable the delivery of fully formed semantic models. Datasets are effectively useless for any self-service service deployment which utilizes a central, certified model without it.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
This feature has to be implemented if we are to be able to implement an IT managed self-service solution with centralised, certified datasets. I.e. allow trained report authors in the business to combine IT managed SSAS or Power BI datasets with other sources that perhaps haven't made it into the centralised and certified dataset yet.
I would estimate each vote for this feature could represent 100s of users (and licenses!)
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
It would be great if you could provide at least a timeline for the feature, It will be a game changing for the BI platform and easily transform any domain by connecting history to present.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
any updates?
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
I've seen other BI tools that allow you join two cubes based on a dimension attribute in SSAS
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
When will this feature be updated ?
Connect 2 SSAS with composite model, That is the big evolution conception of BI really !
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Would be awesome to get some info when you wanna introduce it :-)
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Being able to connect to several datasets from the same report would definitely be a complete gamechanger. Sooo much work goes in to creating a well-worked dataset (with hundreds of measures, dosens of tables etc etc) that its really a nightmare trying to recreate that in several different datasets, and then keeping it current and correct in all these different datasets. JUST NEEDING ACCESS TO THE SAME MEASURES AND DATA in several reports should be easy, if Microsoft wants to be a real market leader