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

951bbc18 9cb7-45ec-a69f-01756134379f on 16 Aug 2020 04:20:37

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

It will be fantastic if PowerBi allow us to Connecting to multiple data sources with IMPORT and Connection live in the same powerbi file. I need to do a Connection live using a CUBe and also import some excel table and today PowerBi is not support this. thanks.Miriam

Sander A.'s profile image Profile Picture

abd2cda6 c7d7-ea11-a813-000d3a563be2 on 16 Aug 2020 04:20:31

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

Would be super if we could combine extra data with our Enterprise Multidimensional cubes

Sander A.'s profile image Profile Picture

40a09d8c 56d3-4b6a-acc3-d531cae7f099 on 16 Aug 2020 04:20:01

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

Coming from Tableau where I used this feature (connecting to multiple datasets, both on a local drive or on Tableau server) in MANY scenarios, it was extremely helpful (consistency, consolidation, multiple copies of data sources, efficiency, etc.. etc..). As some mentioned already, it is a game changer indeed!

I read a few comments here and there like: "why do you need multiple datasets when you can create dashboards from multiple datasets?" or something along those lines. My response to these comments would be: If you are dealing with multiple and/or big data sources, you will appreciate this capability! Also, you just need to use this capability once and I'm quite certain the comments would be of a different tone.

So it goes without saying, I would love to see this feature and capability in Power BI.

Sander A.'s profile image Profile Picture

9ed9482d 2525-405e-b466-68b687ac0e34 on 16 Aug 2020 04:20:01

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

This functionality would be a GREAT add and give us much more flexibility!

Sander A.'s profile image Profile Picture

5f3b250e 0c6b-4b0b-a2b4-71183a2cda3b on 16 Aug 2020 04:19:49

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

Please

Sander A.'s profile image Profile Picture

30632c8b 0075-44ba-abab-891c3d79c430 on 16 Aug 2020 04:19:40

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

Yes please!

Sander A.'s profile image Profile Picture

ed6211b5 59d0-4a35-9e74-bc69d4518b17 on 16 Aug 2020 04:19:40

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

Can't believe this still hasn't been addressed...

Sander A.'s profile image Profile Picture

cc5e18c0 2217-4a86-ad00-b75891f681dc on 16 Aug 2020 04:19:37

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

Please add this

Sander A.'s profile image Profile Picture

cca3b4fe 341b-4612-8d55-4ee5e8c0b701 on 16 Aug 2020 04:19:12

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

Its a huge limitation, struggle to see why power bi doesnt support microsofts own SSAS tabular.

Sander A.'s profile image Profile Picture

1c820172 0c7f-4222-b27f-7833f5099756 on 16 Aug 2020 04:19:10

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

Please add this functionality. This is a huge limitation.