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)
Agree very much wanted feature
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
I work in a fairly large company (>6000 employees), where we are considering switching to Power BI. However, if we are not able to enrich our data without having to download all of it every time(!), this will not be a valid option for us. Please consider including this feature, as it really will open up for using Power BI in a a professional setting.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
'Agreed. The ability to expose the base modelling features in PowerBI when connected to a live SSAS MD or tabular data source, are exactly what my current client need. Specifically:
- grouping / binning
- query multiple data sources
- add calculated members
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
This is a much needed feature...really surprised that Power BI doesn't allow for this. We're in the processes of switching platforms for our dashboards from Excel to Power BI. In Excel we are able to set up multiple report connections, including SQL tables and cubes. However, with Power BI, we're finding this to be a challenge. This would be a great addition!!
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Definitely needed
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
this is DEFINITELY needed! Very surprised it is not currently available
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
I am very surprised this is not yet possible. We desperately need that feature.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Totally agree this is a much-needed feature. I imagine one concern is about putting visuals from different sources on the same report, and the fact that there would be no interaction. I think this is a choice the report designer would have to make.
In Excel, I can add a slicer and a pivot from Data Source A, and another pivot from Data Source B. The slicer will not slice the pivot from B. I know that, and it's my responsibility to design my report to make that clear to my user. I think the same is true for Power BI - more important to have this feature and learn how to show intent through design, rather than not have it and lose critical functionality for the sake of keeping things simple.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Good feature to add and very useful.
RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)
Combining a live cube connection with data from other cubes or live connections, or other local data sources, has many immediate and obvious applications, and is something I and many others really miss in Power BI today!