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.

955 votes
Sign in
(thinking…)
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 →

53 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • 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.

  • Shane Glasheen commented  ·   ·  Flag as inappropriate

    Definitely would add value for us since our SSAS cubes are developed per subject area and it's not feasible (nor desirable) to have to create a single giant model/cube to work around these limitations of Power BI.

  • Anonymous commented  ·   ·  Flag as inappropriate

    until composite models are resolved for SQL Server Analysis Services I really can not use the product and have to resort back to Excel Power Pivots.

  • Anonymous commented  ·   ·  Flag as inappropriate

    @Microsoft: Please do something about this, as it is crucial for so many companies.

  • Vivek commented  ·   ·  Flag as inappropriate

    This would really be a game changer, at least for us. We have several models built for each functional area e.g. Sales, Financials, Expenses, Operations and would like to connect to several of these in a single report to show impact of one area over the other.

← Previous 1 3

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.