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.
Lamin Jobe commented
Also add possibility to mashup with xlxs
Yael Ziv commented
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...