Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
karaoan
Kudo Kingpin
Kudo Kingpin

Composite models working with live SSAS Tabular Connection?

We absolutely love the concept of the newly announced Composite Model feature in July 2018 but it doesn't seem to support an SSAS Tabular live connection? Composite Model is turned on but in our existing reports with SSAS live connections there is no way to add other sources respectively have the "dual storage" option? Anyone know if/when this will be supported?

 

Martin

 

Enterprise Planning, CPM & Writeback in Power BI -> Acterys

 

13 REPLIES 13
Anonymous
Not applicable

Please check this one 

 
 

Modeling

Model view enabled for live connect (preview) .When you live connect from Power BI Desktop to an Analysis Service model or a dataset published in the Power BI service, the model view is now enabled.

souldiv
Frequent Visitor

Composite models on AS tabular models for live connect is being worked on. Still no timeline available


@karaoan wrote:

We absolutely love the concept of the newly announced Composite Model feature in July 2018 but it doesn't seem to support an SSAS Tabular live connection? Composite Model is turned on but in our existing reports with SSAS live connections there is no way to add other sources respectively have the "dual storage" option? Anyone know if/when this will be supported?

 

Martin

 

Enterprise Planning, CPM & Writeback in Power BI -> Acterys

 



.

Anonymous
Not applicable
Anonymous
Not applicable

This is a feature that I would love to have. Any updates on this?

Anonymous
Not applicable

Would love to have this feature. Any updates?

Anonymous
Not applicable

Agree, it would be great to have. I havent seen any updates yet. I asked about this on the Power BI youtube-channel and the reply seemed to confirm that ms is working on this. But as far as I know, MS havent not said how this functionality will be implemented, ie will both tabular and multi cubes be suppported? Will the functionality require a later version of SQL Server?

I just wondered the same thing. Not working for my LIVE connection to my AS instance. The docs, unfortunately, are very clear by stating that it can work with a DIRECT QUERY connection, i.e. which is used for regular SQL tables. 

dmarkle
Frequent Visitor

Yeah, it was a bit of a letdown to see that live Tabular connections aren't supported yet.  I hope it's coming.  When it does, I can see the value of our data warehouse expanding greatly.

Anonymous
Not applicable

I rewatched the video where the preview of composite models was announced

 

https://www.youtube.com/watch?v=Mtig3rmIUe0

 

And around 7:25 the presenter says, in the preview period "will only support tabular sources", and "multi dimensional sources are not supported yet"

This is where I think I misunderstood, it probably should be understood as tabular = data in tables, not tabular cubes.

 

Still it would be great to get a clearification the ms inteends to release support for multi dimentional cubes for composite models. It would planning the roadmap forward much easier.

 

 

Anonymous
Not applicable

I am wondering the same thing.

In the youtube-video for the july-release of power bi, it was said the the composite model would work for tabular, but not multi cubes. But when I read the article on composite models (link below), it says that analysis server is not supported. The tabular cubes runs only under analysis server, dont they?

https://docs.microsoft.com/sv-se/power-bi/desktop-composite-models

Anonymous
Not applicable

Wondering the same thing. I have created a data model in Analysis Services and deployed it to Azure Analysis Services Server. In Power BI I can only connect via live connection or import. When using live connection I do not have further access to get data from other sources. How can I get access to composite models when using Azure Analysis Services?

RichardV
Advocate IV
Advocate IV

I have exactly the same question as Martin. Will it become available for SSAS tabular live connection too?

In my case i need this feature with multidimensional model, i think this feature will arrive soon, a least i hope so. i tested with july update and don't works.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors