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

3bc27a54 4bd2-48e9-927d-f818f9fb3dd1 on 16 Aug 2020 04:08:06

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

I agree completely with this suggestion. Funny: as soon a a great feature is released (composite models), users immediately want more!!

Sander A.'s profile image Profile Picture

42ed5d80 1eb0-4810-a7b6-3ea330b50c8b on 16 Aug 2020 04:08:05

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

Hey Avi, looks like we've got the ball rolling. I am really looking forward to this new feature. Keep up the good work. Thanks!

Sander A.'s profile image Profile Picture

4c4fdd05 af0a-49ef-ba55-f74a4490c46b on 16 Aug 2020 04:08:04

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

Friends, the Microsoft team has done an amazing job with the Composite Model. This one feature would take it to a while new level. If you are considering voting for this idea, please watch my appeal video here...and then smash that Vote button :-)

https://youtu.be/UbGRpevvZU0

Sander A.'s profile image Profile Picture

02409ae8 d181-42b7-8444-9175957ab9e5 on 16 Aug 2020 04:07:51

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

Same here!

Sander A.'s profile image Profile Picture

051a63cc e9ce-4236-88c0-5ddb3d9d858a on 16 Aug 2020 04:07:50

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

This feature is great!

Sander A.'s profile image Profile Picture

42ed5d80 1eb0-4810-a7b6-3ea330b50c8b on 16 Aug 2020 04:07:47

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

The feature would definitely supercharge Power BI as external data could be easily combined with central data warehouses running SSAS tabular...

I would love to see this feature in upcoming releases.

Sander A.'s profile image Profile Picture

27369838 96d8-e611-8100-5065f38a2b21 on 16 Aug 2020 04:07:47

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

Our local gov dept needs this please please please. Live connection to Power BI datasets.

Sander A.'s profile image Profile Picture

d0aca558 5e84-498a-9cd8-6d63f1fe0aea on 16 Aug 2020 04:07:39

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

Yes, I want this too.
for Live Connection to Power BI Services, and Import from Excel

Sander A.'s profile image Profile Picture

fc6a2940 cb57-4423-9835-df4ff24efc7d on 16 Aug 2020 04:07:39

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

Connect live to my IT SQL 2016 SSAS Tabular cube with composite modelling is a must and will not only save time and money but will deliver faster results for my key uses. It has to be a must have

Sander A.'s profile image Profile Picture

0a2b8164 5120-4b6f-93d2-bc9bb613a84a on 16 Aug 2020 04:07:38

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

Yes, I want this too...I want business users to have that flexibility!We cannot import everything into the cube and if someone wants any adhoc reports integrating excel data and cube data...It adds more value and encourages them to use Power BI. I agree with Avi...it's fact!