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

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.

    • jeroenterheerdt's avatar
      jeroenterheerdt
      Icon for Microsoft Employee rankMicrosoft Employee
      5 years ago

      thanks for letting us know!

    • charrington's avatar
      charrington
      Icon for Advocate V rankAdvocate V
      4 years ago

      Hi,

      I am also working with composite model with Direct Query for Power BI Datasets, and with some calculation groups. I was delighted at first to see that this combination seems to work! 😊

       

      But althought this works well for me in the desktop, once published to the service I cannot refresh the model, and get this error:

      I have not added any columns nor calculated table (other than the calc group) to the DQ dataset. So I am thinking I hit the imitation here.

      Do you have the same behavior?


      It looks pretty close to work, but if we cannot refresh the model, well, it's useless.

       

      Thanks

      Christian

      • jeroenterheerdt's avatar
        jeroenterheerdt
        Icon for Microsoft Employee rankMicrosoft Employee
        4 years ago

        correct, this is an existing limitation.