Skip to main content
Microsoft Idea

Power BI

Completed

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

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

Anchal Dwivedi 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

Okan CANPOLAT 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

Aaron Gourlay 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

Joel-Stephane-Loic Ngando-Kouo 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

Nagasatya Devarakonda 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

Power BI User 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

Brad Dietz 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

Braden 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.

Sander A.'s profile image Profile Picture

Rajaniesh Kaushikk on 16 Aug 2020 04:13:02

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

We are eagerly waiting for this feature

Sander A.'s profile image Profile Picture

Rajaniesh Kaushikk on 16 Aug 2020 04:13:02

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

Any timelines for this feature

Merged Idea (7)