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

c356b046 2755-49d3-9f50-8aeffdd4ebe0 on 16 Aug 2020 04:19:03

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

This is still the ultimate goal, I saw this announcement....does anyone know if this can be extended to SSAS on-prem? Not Azure AS?

https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/business-intelligence/composite-models-over-power-bi-azure-analysis-services-datasets

Sander A.'s profile image Profile Picture

8bc85730 537e-401c-b5e1-4e0678addc82 on 16 Aug 2020 04:18:30

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

Definitely needs this feature to create a summary page

Sander A.'s profile image Profile Picture

4b3351a1 507c-4282-8e3e-a1b2a9b2f2c9 on 16 Aug 2020 04:18:28

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

Josh BI UK. I would beg to differ. Is Business Users need to combine other data, they are going to do it. Allowing them to do this in Power BI gives the Admins some opportunity to monitor that (possibly using Telemetry in Power BI.com to check which Models have been deployed). Otherwise, users would do this but in Excel or Power Point or some other way. It's impossible to stop that. you know what they say...if you can't beat them..

https://führerschein-online-kaufen.com
Haben Sie Angst, einen gefälschten Führerschein online zu kaufen? Keine Angst, wenn wir hier sind! Sie können einen gefälschter Führerschein kaufen online auf dieser Website und an eine Adresse Ihrer Wahl liefern lassen

Sander A.'s profile image Profile Picture

928c1039 c710-4d44-aa1a-5ef77601c328 on 16 Aug 2020 04:18:15

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

Would love to see this implemented as well.

Sander A.'s profile image Profile Picture

43e0297e 7640-47c6-8fad-5b727b4bb963 on 16 Aug 2020 04:18:15

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

Could you please give an update of whenever you plan to implement this. It's really important in a self service perspective to get this in place.

Sander A.'s profile image Profile Picture

dd0e1c20 52d9-4a93-a15e-a069b75a59e3 on 16 Aug 2020 04:18:14

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

Please add soonest. Even if we can just be able to create virtual tables in PowerBI connected to SSAS

Sander A.'s profile image Profile Picture

20b81274 798c-4c39-abfa-6b3ad79b4af9 on 16 Aug 2020 04:18:00

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

Implementing this would absolutely cement Power BI as a viable analytic and data visualization tool.

Sander A.'s profile image Profile Picture

c7032029 2dd5-4c3a-b7ec-64f362c62890 on 16 Aug 2020 04:17:24

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

We are in the same boat needing the ability to create summaries from multiple existing datasets.

Sander A.'s profile image Profile Picture

50c27100 56b8-4f18-a48e-f5746d6c34a1 on 16 Aug 2020 04:17:23

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

My team has created around 22+ reports and now there is an ask from management to create a summary page linking back to those reports. This feature would be a lifesaver for me. I can't really do much with PBI dashboards.

Sander A.'s profile image Profile Picture

ac2aeced 26b6-4ed4-8426-3afc102a952c on 16 Aug 2020 04:17:21

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

We are about to hit 2020 - Backlog update appears to be Sept 2018... ?!! At least allow disconnected slicer tables...as an interim ?