How can we improve Power BI?

Data Modelling when connecting to SSAS Tabular

We need to be able to mashup data online with enterprise data in a SSAS cube. To do this, we'll need the data modelling feature accessible when connecting to SSAS Tabular.

102 votes
Sign in
(thinking…)
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

T.J. Brown shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

8 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Andrew T. commented  ·   ·  Flag as inappropriate

    It seems like this shouldn't be a problem. You CAN add data from SSAS to a report with SQL Data, but you can't start from a SSAS model and add data from SQL sources. For me, this would be the more sensible approach. I have most of the data I need in my SSAS model, I just have some other bits out there I want to combine sometimes.

  • Ralph Kemperdick commented  ·   ·  Flag as inappropriate

    This is indeed a key missing feature and hard to understand why Excel can connect to multiple sources likes SSAS and other, but PowerBI cannot. It might become a kind of complex problem under the hood, but in my case it would be sufficient to render the different data sources on different Report pages. May be this is easier to accomplish?

  • John commented  ·   ·  Flag as inappropriate

    Yep. Mixing internal and external data is important to us.

  • RAZ commented  ·   ·  Flag as inappropriate

    This feature would make a big impact for users with other tools wanting to change. This would rock the hell out of Power BI

  • mahimabedi commented  ·   ·  Flag as inappropriate

    This is a big road block for us. We need to be able to make changes to enable true self service BI.

  • Jay Eckles commented  ·   ·  Flag as inappropriate

    This is needed not just to mashup data, but to allow users to make minor changes like establish new hierarchies or groupings.

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.