Skip to main content
Microsoft Idea

Power BI

Completed

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

Vote (2403) 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 18 Mar 2022 04:15:01

The preview is underway: DirectQuery for Power BI datasets and Azure Analysis Services (preview) | Microsoft Power BI Blog | Microsoft Power BI. Please try it and provide feedback.

Comments (254)
Sander A.'s profile image Profile Picture

Josh_BI_UK on 16 Aug 2020 04:06:48

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

I actually prefer the fact that if a user connects to a SSAS Tabular model, they can't add any other sources. If they could, it would defeat the purpose of a controlled model?

Sander A.'s profile image Profile Picture

Brandy Olsen on 16 Aug 2020 04:06:48

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

I LOVE the composite models feature! Please release this for full use soon! And as mentioned above....Please add the ability to use composite on all the different data sources including SSRS! The more the better!

Sander A.'s profile image Profile Picture

Power BI User on 16 Aug 2020 04:06:48

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

MUST HAVE

Sander A.'s profile image Profile Picture

Power BI User on 16 Aug 2020 04:06:48

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

This would be huge for our planned method of creating shared data models across the organization that could be pulled in together as needed for individual solutions.

Sander A.'s profile image Profile Picture

Mark Appleton on 16 Aug 2020 04:06:44

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

This feature would be very handy for the work I do.

Sander A.'s profile image Profile Picture

ryo on 16 Aug 2020 04:06:44

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

yes it's a good idea for SSAS tabular it's a principal feature for Business Intelligence. composite multiple SSAS connections for cube and link by slice time for example. If there is this fonction Power bi will the best BI feature.

Sander A.'s profile image Profile Picture

Tibo on 16 Aug 2020 04:06:32

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

'+1

I was so disappointed when I saw the SSAS listed as a limitation of that new feature...

Sander A.'s profile image Profile Picture

Saber on 16 Aug 2020 04:05:38

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

Most of BI project has more than one cube, it is very high demand in our business.

Sander A.'s profile image Profile Picture

Tinh Tam Mai on 16 Aug 2020 04:04:55

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

This is a very important and critical feature that will facilitate the deployment of Power BI and associated MS stack on the data side. We need this ASAP.

Sander A.'s profile image Profile Picture

Fergal Power BI User on 16 Aug 2020 04:04:52

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

This is a show stopper for my organization we should be able to use multiple data sources in SSAS tabular model. Please add this feature ASAP.

Merged Idea (7)