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

3a0e2db7 ddee-4091-9b98-c59fac32899e on 16 Aug 2020 04:00:34

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

please support

Sander A.'s profile image Profile Picture

e7061f22 0d5a-4e9e-9da1-3a9cb7db62f0 on 16 Aug 2020 04:00:34

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

combine multiple ssas data source

Sander A.'s profile image Profile Picture

d7f3ef76 3098-4a47-91d8-4f7642abb582 on 16 Aug 2020 04:00:34

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

we really need this feature, right now we have no choice, instead to use import excel

Sander A.'s profile image Profile Picture

ed25fe51 a73b-4340-91c0-3c208000662c on 16 Aug 2020 04:00:30

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

this is what we need ,hope it comes true very soon

Sander A.'s profile image Profile Picture

6f3104f5 7df8-49d9-b999-7ada3d52f246 on 16 Aug 2020 04:00:30

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

Please Microsoft pay more attention to this function, thanks

Sander A.'s profile image Profile Picture

0d38f85d 26d1-46df-988e-3083993f4227 on 16 Aug 2020 04:00:30

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

Please Microsoft pay more attention to this function, thanks

Sander A.'s profile image Profile Picture

76a09cd4 7b1e-4371-9e77-10f7c124214d on 16 Aug 2020 04:00:30

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

NEED

Sander A.'s profile image Profile Picture

2980723a 86ac-410f-abb5-0e52b6913c97 on 16 Aug 2020 03:59:58

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

It's need this feature in PowerBI desktop & PowerBI SSRS.

Sander A.'s profile image Profile Picture

7a8131d1 1955-4ac8-af09-10e98213652a on 16 Aug 2020 03:59:23

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

Add this Feature

a) To combine multiple SSAS data sources.

Say, if we are combining from two different Sales (platform, product, area) cubes and present as one single place like dashboard.

b) To combine SSAS and other data sources.

Say, if we have Sales Cube and may want to have SQL (lookup, category) tables i.e., Having a model on top of a Cube data in Power BI.

Note:
I understand this may lead to less capabilities of SSAS and more behave like Flattened (table) structure.

Sander A.'s profile image Profile Picture

5f8c5346 63f8-4f8e-8b26-46e041600605 on 16 Aug 2020 03:59:05

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

Currently, once you connect to a Power BI Service/Online Dataset you cannot add additional data sources. We have several datasets we'd like to put in the same report, but can't because they are over the 1GB limit on size. If we could live-connect to them all in Power BI Desktop this would help.