Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
We're migrating from a SSAS Multidimensional on premise to Azure Analysis Services (Tabular),
Composite Model is a very interesting feature for our end users, but I would like to use Calculation Group in our model.
In the Preview the combination of Composite Model and Calculation Group is mentioned not to be supported.
'Calculation groups on remote sources are not supported, with undefined query results.'
Will it be supported in the (near) future?
Does it make sense to add Calculation Group to our model?
- jeroenterheerdt
Thanks for your interest in the feature, we're still working through a couple of things, this is one of them. However, depending on how you use it this is not going to be supported or might be. In essence, defining a calc group on a remote source is not supported (and I don't think it will soon). However, you will soon be able to define calc groups on your local model.
What do you mean by calculation group on remote source is not supported ?
do you mean in combination with Composite Model ?I defined a Calculation group in my model, deployed it to Azure Analysis Services and it works fine.
similar when deploying it to on-prem Analysis Services- jeroenterheerdt
with remote source I mean a AAS or PowerBI dataset that you connected to using DirectQuery: using a calculation group on such a source is not supported.
