Skip to main content

Power BI

Under Review

Composite models when connected to AS models (PBI datasets and Azure Analysis Services)

Vote (2267) Share
Sander A.'s profile image

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)
Sander A.'s profile image Profile Picture

53f9d7dc 6cc5-4289-825a-dd56569606b2 on 16 Aug 2020 04:14:29

RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)

Not an easy task no doubt but this would be THE killer feature.

Sander A.'s profile image Profile Picture

9da741f8 707a-4977-9d61-cb7ae3682b2f on 16 Aug 2020 04:14:27

RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)

This functionality would definitely be useful as more people want reports that based on online applications such as Project Online and Sharepoint.

Sander A.'s profile image Profile Picture

b36d9803 b19a-48f1-92a1-95c514318d95 on 16 Aug 2020 04:14:21

RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)

This would be very helpful, one report can be created using multiple datasets from different departments.

Sander A.'s profile image Profile Picture

9725491d a7a6-4a97-9e61-8824d18d8fa9 on 16 Aug 2020 04:14:18

RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)

Please keep up-to-date. We need it.

Sander A.'s profile image Profile Picture

2bc6a9a5 2ced-49ae-a062-380f30b77058 on 16 Aug 2020 04:13:49

RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)

Agree this would be useful as would allow for smaller focussed data models that can be included or discounted depending on the business need

Sander A.'s profile image Profile Picture

2f833645 1952-4b83-af17-45c940d4f30c on 16 Aug 2020 04:13:45

RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)

I need this feature , some one have information about release date please

Sander A.'s profile image Profile Picture

079f3d48 d5b7-ea11-a812-000d3a579c34 on 16 Aug 2020 04:13:44

RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)

This is a must have feature in Power BI. It is currently a make or break situation in our organization for a lot of scenarios. Please release it ASAP.

Sander A.'s profile image Profile Picture

4b7f22ee 56bc-42b4-be85-afd8dfbbfad7 on 16 Aug 2020 04:13:43

RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)

Our company needs this feature!

Sander A.'s profile image Profile Picture

ee706f0d ae68-4766-af29-06de458e3182 on 16 Aug 2020 04:13:19

RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)

3 years and counting since the original idea...

Sander A.'s profile image Profile Picture

c356b046 2755-49d3-9f50-8aeffdd4ebe0 on 16 Aug 2020 04:13:18

RE: Composite models when connected to AS models (PBI datasets and Azure Analysis Services)

This would be great! Sometimes the tabular model might be focused on one aspect and we just need to integrate another piece of data for a specific report...this would enable us to kind of compartmentalize things.

For example there may be a 'Sales' tabular model for the entire organization, but for one portion sales are tied heavily to maybe the weather. That group may want to integrate weather data with their sales analysis...without this feature they either: A. have to make their own model to include the weather data or B. get the enterprise developers to include weather data (which possibly no one else will use) into the tabular model.