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

4cbba17a b71a-491a-91da-6e571d53be6f on 16 Aug 2020 04:16:03

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

Would be awesome to get some info when you wanna introduce it :-)

Sander A.'s profile image Profile Picture

a6a3334e 5352-4ef4-98a7-0b350c73e904 on 16 Aug 2020 04:16:00

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

Being able to connect to several datasets from the same report would definitely be a complete gamechanger. Sooo much work goes in to creating a well-worked dataset (with hundreds of measures, dosens of tables etc etc) that its really a nightmare trying to recreate that in several different datasets, and then keeping it current and correct in all these different datasets. JUST NEEDING ACCESS TO THE SAME MEASURES AND DATA in several reports should be easy, if Microsoft wants to be a real market leader

Sander A.'s profile image Profile Picture

6a40a528 764b-4913-a2d8-ac4cc9a2cfc6 on 16 Aug 2020 04:15:54

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

This missing functionality is potentially meaning we need to buy and deploy a non MS solution for our data reporting/analytics.

Sander A.'s profile image Profile Picture

595292ed 864b-430e-a572-16557d7e80f6 on 16 Aug 2020 04:15:54

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

I was connecting to Cube and then found out that new connections to database is not supported, so, decided to Switch to Spotfire.
Connecting to different source would come as a necessity

Sander A.'s profile image Profile Picture

1a2d4c29 7660-4c37-9714-06ff6bb976c2 on 16 Aug 2020 04:15:54

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

This will greatly enhance the usability of Power BI dashboard-style capabilities

Sander A.'s profile image Profile Picture

f6c022c3 09f9-4607-915f-62890b54ce00 on 16 Aug 2020 04:15:40

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

Can we make more calculated measures from the measures already present in the cube. If not then is there any other way to do this. It can easily be done when we connect to the Data warehouse. but cannot be done when we connect to the cubes. Is it right.

Sander A.'s profile image Profile Picture

86ad44cd 71e9-4117-b85a-cd1da6840582 on 16 Aug 2020 04:15:40

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

I hate being unable to add non-service data sources to a report that uses service data. This at least would allow a base dataset to be used for multiple complex models. Is this anywhere on the roadmap, because it's absence severely limits the usefulness of ever using service datasets?

Sander A.'s profile image Profile Picture

87aec46c b3f8-40f4-9649-a3103ead09a9 on 16 Aug 2020 04:15:38

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

Is there any news? It's needed urgently

Sander A.'s profile image Profile Picture

13e47c54 cee9-48be-b512-8b51ac895ee9 on 16 Aug 2020 04:15:36

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

I understand that it would be challenging to implement but will take Power BI to next level

Sander A.'s profile image Profile Picture

c12104c6 553a-44e2-b420-b1043f6fd3e4 on 16 Aug 2020 04:15:29

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

Please implement. Like others as said, this is a much needed feature.