How can we improve Power BI?

Make SSAS Live Connections/DirectQuery more functional/flexible

I love the fact that we can make live connections to a SSAS Tabular model in DirectQuery mode as it allows us to share common semantic models on our enterprise data. However, with a live connection we lose very important features such as: renaming fields, adding calculated fields, grouping and binning to name just a few. Ideally, when I make a SSAS live connection these types of functions would remain enabled.

One option might be to allow users to import the SSAS tabular model in live (DirectQuery) mode.

27 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Chris Klimm shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Yael Ziv commented  ·   ·  Flag as inappropriate

    adding to what was suggested here: many features are disabled when connecting live to SSAS Tabular model. basically all the AI capabilities are gone (Q&A, insights, analyze) and even the very basic capability of creating a new column...

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.