Alex on 08 Jul 2017 00:33:29
Similar Power BI functionality for SSAS live data
I've noticed that much of the functionality of Power BI desktop is disabled when connecting to SSAS live data. Examples of this are creating a hierarchy, setting a category for a column, setting a format for a column, etc.
As it stands, you have to do most of that in your SSAS model/database for it to function in Power BI. During a recent demo, a Microsoft rep said that Power BI had SSAS under the hood, so I'm assuming that's part of the complication?
I've seen suggestions for certain features, but the expectation of the end-user of Power BI should be the same regardless of which source we're connecting to.