Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Microsoft EmployeeThanks 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.
I ran som more tests.
Created a calculation group in the model and deployed it to AAS.When connecting PowerBI to the model I can use the calculation items in new measures definition.
When adding an excel file as extra source (composite model) the measures in the model using calculation items still work. (YTD PY),and I can use them in new measures definitions on measures in the model too.
But they cannot be applied to the measures (Budget Value) coming from the excel file.This looks great.
The calculation group defined in the model still works and can be used on measures in the model.
If they don't on the measures from the added source, is acceptable.Based on this we can continue our developments with the calculation groups.
looking forward to the final version of composite model.
- jeroenterheerdt
thanks for letting us know!