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

1389f448 8ab1-4b2a-a237-4b654d2173e4 on 16 Aug 2020 04:09:03

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

Composite model toghether with SSAS live connection would help us a lot to solve ad hoc requests properly and in a fast way.

Sander A.'s profile image Profile Picture

9b40ea38 421f-4d84-96ee-be250b2d0974 on 16 Aug 2020 04:08:48

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

this would allow to use Power BI service as a central repository of certified datasets that could be reused on needed

Sander A.'s profile image Profile Picture

79575d1e 5e0d-4dbd-9b23-629090aaf213 on 16 Aug 2020 04:08:44

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

Having more than one cube in a report is very important for several important report we need to deliver. Always relying on the cube itself getting fatter and fatter to become the uber-cube-that-solves-it-all is not feasible in many non-trivial cases.

Sander A.'s profile image Profile Picture

6dc6b1ab 4bc9-4569-836b-245fd8316134 on 16 Aug 2020 04:08:40

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

Eagerly waiting for this feature. It will help us bridge the gap between performance and extendability. Hoping that this feature is part of the next release for Power BI.

Sander A.'s profile image Profile Picture

c14fed1a 17fa-493e-b7a0-8b360b025891 on 16 Aug 2020 04:08:35

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

This should be the next big feature for Power BI. Definitely a must have feature!

Sander A.'s profile image Profile Picture

3a25beee 96ac-4276-89d8-0c1cac25f1cc on 16 Aug 2020 04:08:35

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

Another vote for this. We have data sources that for one reason or another cannot be pulled into our tabular model but that users really want mashed up into their reports and dashboards.

Sander A.'s profile image Profile Picture

b2bf64b6 765f-42ce-a61d-e7450cab37c6 on 16 Aug 2020 04:08:32

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

I would also like this idea to work when connecting to live to tabular models. So it is possible to connect to multiple ssas in one desktop file in the same way as with excel.

Sander A.'s profile image Profile Picture

5c32ef73 3f81-4aa8-9cc0-94d6e5d50136 on 16 Aug 2020 04:08:32

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

I currently work across a number of data sources and being able to tie them together is a must for me to create and represent the outcomes in a effective way. I would really need this function available for me to utilize PBI for my daily work flow.

Sander A.'s profile image Profile Picture

89adcc58 1510-4a42-a78c-3c2fc991197f on 16 Aug 2020 04:08:28

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

I agree completely with this suggestion.

Prunella Viens
https://sejour-guadeloupe.weebly.com

Sander A.'s profile image Profile Picture

23b7c9ec 844a-43fd-98a2-5fc62f225ea4 on 16 Aug 2020 04:08:19

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

It is very important feature in order to make a comprehensive Executive report. We have a requirement but we are stuck due to this.