How can we improve Power BI?

Composite models when connected to SQL Server Analysis Services Tabular (SSAS)

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.

1,083 votes
Sign in
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Sander A. shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →


Sign in
Sign in with: Facebook Google
Signed in as (Sign out)
  • Jordan Hudson commented  ·   ·  Flag as inappropriate

    To really enhance the use of Power BI within our company this is essential as we are rolling out both Tabular and Power BI but would like the ability to connect more sources along with a Tabular model connection!

  • Nagasatya Devarakonda commented  ·   ·  Flag as inappropriate

    This is a must have feature in Power BI. It is currently a make or break situation in our organization for a lot of scenarios. Please release it ASAP.

  • Braden commented  ·   ·  Flag as inappropriate

    This would be great! Sometimes the tabular model might be focused on one aspect and we just need to integrate another piece of data for a specific report...this would enable us to kind of compartmentalize things.

    For example there may be a 'Sales' tabular model for the entire organization, but for one portion sales are tied heavily to maybe the weather. That group may want to integrate weather data with their sales analysis...without this feature they either: A. have to make their own model to include the weather data or B. get the enterprise developers to include weather data (which possibly no one else will use) into the tabular model.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Hi Charles,

    This was placed in the backlog in September. Any update on the planning for implementation? This is urgently needed for us and our users.

    BR, Oscar

  • Ola commented  ·   ·  Flag as inappropriate

    I agree that this a much needed feature if Power BI wants to be scalable and managable. However I can see why it would not be easy, as part of the attraction with Analysis services live query is that the data and the security model is hosted on the analysis server, not Power BI service. Multiple models hosted on the same analysis services server would be relatively "easy", but even then conflicting roles needs to be resolved. Adding connections from other sources into the Power BI service as well, would require the security model to be on the service platform. I acctually would welcome that move - a Power BI service integration layer with tenant level security models, but without the need to import that data hosted on live/direct query sources (Please don't ask how that would work :) I guess the model would have to be pushed to the sources).

  • Johnny commented  ·   ·  Flag as inappropriate

    I urge you to consider implementing this feature asap. Without this we are forced to govern all sorts of non-sustainable workaround solutions even for the most simple scenarios.

  • Jonas Halldén commented  ·   ·  Flag as inappropriate

    We have colleagues who feel forced to move to Tableau because of only this issue. (Oh no!) We need this in Power BI badly! Thanks!

  • Yves Haenen commented  ·   ·  Flag as inappropriate

    I think customization through "Composite Models" with SSAS tabular live connection could give a boost to our report.

← Previous 1 3 4

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.