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

John 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

Merlin 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

Josiah 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

Amir 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

Frank 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

AndreasK 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

Sriram 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

Nate Brunner 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.

Sander A.'s profile image Profile Picture

Power BI User on 16 Aug 2020 04:15:26

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

We need this feature asap

Sander A.'s profile image Profile Picture

Stuart Charles on 16 Aug 2020 04:15:14

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

We desperately need this to be able to deliver an IT managed self service solution. Provide enough flexibility for the business to combine their own data with watermarked trusted data sources.

Merged Idea (7)