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

Power BI User on 16 Aug 2020 04:10:17

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

This would be hugely beneficial to our reporting.

Sander A.'s profile image Profile Picture

Leonel Castellano on 16 Aug 2020 04:10:15

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

Want this so bad. Can I vote again?

Sander A.'s profile image Profile Picture

Andreas Enstrom on 16 Aug 2020 04:10:14

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

Any update on this much needed feature?

Sander A.'s profile image Profile Picture

D. Pearce on 16 Aug 2020 04:10:10

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

Yet another reason I prefer to create reports in Excel and simply publish them.
IMHO, there are *so many* features in Excel that are crucial for business data analysis in custom ways that are independent of the source(s).
PowerBI MUST START trying to get equity with many of the Excel Data Manipulation functions.

Sander A.'s profile image Profile Picture

Power BI User on 16 Aug 2020 04:10:10

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

'@Microsoft: Please do something about this, as it is crucial for so many companies.

Sander A.'s profile image Profile Picture

Leonel Castellano on 16 Aug 2020 04:10:02

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

This would be a great update!

Sander A.'s profile image Profile Picture

Power BI User on 16 Aug 2020 04:10:01

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

Please update, would be magnificent!

Sander A.'s profile image Profile Picture

Vivek on 16 Aug 2020 04:09:59

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

This would really be a game changer, at least for us. We have several models built for each functional area e.g. Sales, Financials, Expenses, Operations and would like to connect to several of these in a single report to show impact of one area over the other.

Sander A.'s profile image Profile Picture

Eric Hartley on 16 Aug 2020 04:09:57

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

This is needed!

Sander A.'s profile image Profile Picture

Kirsty on 16 Aug 2020 04:09:44

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

Completely agree. This would really help with the single source of truth while retaining all the Power BI features that you lose with dataflows (ie. grouping, parameters). Not to mention it can all be done on a pro license, not premium.

Merged Idea (7)