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

ab7e59d5 8730-49b5-ac06-ef6b6082612e on 16 Aug 2020 04:10:56

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

until composite models are resolved for SQL Server Analysis Services I really can not use the product and have to resort back to Excel Power Pivots.

Sander A.'s profile image Profile Picture

f63b896b ce96-4f5a-9769-d7bdca9ff031 on 16 Aug 2020 04:10:22

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

This is a pretty typical use case - it would be very helpful to have this feature.

Sander A.'s profile image Profile Picture

c1892e88 6a11-4f77-a222-300bbdc1754c 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

46b9e921 f56d-4405-8713-28223597e6a6 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

140979dd e6d6-40e2-9458-5fd56085f452 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

bc807bb2 7c35-4b72-a5e2-2cb1b7110229 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

f597cb1c 8432-4acb-a71a-46743a999939 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

46b9e921 f56d-4405-8713-28223597e6a6 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

17c02f60 39b2-4855-8982-e0b3df27e2b9 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

e01b01a0 cbad-41e3-8fb7-15420e4af749 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.