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

Power BI User on 16 Aug 2020 04:09:43

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

BUY HIGH QUALITY REAL/FAKE PASSPORTS,DRIVERS LICENSE(charlselwatson@gmail.com),ID CARDS,Counterfeits Bank notes,TOEFL,IELTS,TOEIC,SSN,divorc

Sander A.'s profile image Profile Picture

Manish Siwach on 16 Aug 2020 04:09:43

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

Composite model is very much needed in PBI Report Server.

Sander A.'s profile image Profile Picture

Lisa on 16 Aug 2020 04:09:43

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

Would like to see this!

Sander A.'s profile image Profile Picture

Colin Eisele on 16 Aug 2020 04:09:39

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

Yes please. We have custom budgets that aren't added into our SSAS because they're very niche. They're tracked manually in excel, currently. Would be great to track them in Power BI instead.

Sander A.'s profile image Profile Picture

Maxime Coron-Dall'o on 16 Aug 2020 04:09:12

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

It would be really useful. Please update it

Sander A.'s profile image Profile Picture

Morten Fammé Hviid-Hansen on 16 Aug 2020 04:09:08

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

This is highly relevant and needed for us enterprise users.

Sander A.'s profile image Profile Picture

Pier1999 on 16 Aug 2020 04:09:08

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

Definitely a ‘must have’ for an enterprise solution. My users work with a live connection to SSAS (cannot download the entire dataset on each worker's machine) but then want to integrate with data on the fly, perhaps coming from the latest market data, which would never made it to the datacentre on time to be useful to the final report.

Sander A.'s profile image Profile Picture

Bhavesh on 16 Aug 2020 04:09:04

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

As far as I know, Microsoft is working on this feature undercover.

Check this video starting from 44:00 Minutes ( Christian Wade with Jeffery Wang)

https://youtu.be/_6lWlunmnpM

Sander A.'s profile image Profile Picture

Marco on 16 Aug 2020 04:09:03

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

Composite model toghether with SSAS live connection would help us a lot to solve ad hoc requests properly and in a fast way.

Sander A.'s profile image Profile Picture

matteo on 16 Aug 2020 04:08:48

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

this would allow to use Power BI service as a central repository of certified datasets that could be reused on needed

Merged Idea (7)