Forum Discussion

tessahurr's avatar
tessahurr
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)

Hit Reply and let us know what you think of the DirectQuery for Power BI datasets and Azure Analysis Services.  To learn more about this feature, please visit this blog post or our documentation.   ...
General Comment
fbouckaert's avatar
fbouckaert
Frequent Visitor
5 years ago

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's avatar
jeroenterheerdt
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

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.

  • fbouckaert's avatar
    fbouckaert
    Frequent Visitor
    5 years ago

    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's avatar
      jeroenterheerdt
      Icon for Microsoft Employee rankMicrosoft Employee
      5 years ago

      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.

      • fbouckaert's avatar
        fbouckaert
        Frequent Visitor
        5 years ago

        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.