Forum Discussion
SQL Server Analysis Services cubos
I have my SQL Server Analysis Services server where my cubes are located, my question is, as from power bi I can join the cubes already have the same characteristics and create a dashbord based on ...
HI Juan-Power-bi,
What type of AS data source are you worked? Tabular or multidimensional cube?
If you mean tabular, current power bi allow you to use measure expression to calculate/design with live mode.
If you are work with the multidimensional cube, current edit features of calculating fields or expressions not availed on it. (For general visual and chart design based on fields, they work well on both two types)
Notice:
power bi data model is stored with AS tabular instance, it can be connected with AS multidimensional but not able to write expressions calculate based on its fields and structures. (data model not woks with multidimensional data source)
Regards,
Xiaoxin Sheng