Anonymous's avatar
Anonymous
Not applicable
4 years ago
Status:
Investigating

Decomposition Tree is not working anymore

The dataset is using a Local Model (DirectQuery to AS, with Azure Analysis Services as the underlying Data Source). It was working last 2 or 3 weeks ago and it's returning an error.

 

6 Comments

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    Status changed:
    New
    to
    Investigating

    Whether have the right access to the data source and the gateway has been configured correctly?

    In additionm, you can click 'See details' to find the detail information about this issue for further.

     

    Best Regards,
    Community Support Team _ Yingjie Li

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thank you for your answer.

    I receive the error on the Desktop as well and have access to the data. 
    Here is the error details, if that can help 🙂 not sure where the TOPPERLEVEL is comig from

     

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    Status changed:
    Investigating
    to
    Investigating

    Perhaps you can check your data source to find this field whether it should return a value as varible, be a vaild table or a function as the error message mentioned.

     

    Best Regards,
    Community Support Team _ Yingjie Li

  • russfai's avatar
    russfai
    Icon for Microsoft Employee rankMicrosoft Employee

    I am having the exact same issue with the exact same error message when using a composite model - both on the service and on my desktop.  It works fine if I use a non-composite model.

     

     

  • russfai's avatar
    russfai
    Icon for Microsoft Employee rankMicrosoft Employee

    I have a connection with Azure Analysis Services as the underlying Data Source.  When I change the connection to a "DirectQuery to AS", the Decomposition Trees stop working with this error message:

     

  • Facing the same issue ( cannot resolve name TOPNPERLEVEL) , any solution yet?