Decomposition Tree is not working anymore

[Anonymous]

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.

[v-yingjl]

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]

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]

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]

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]

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:

[CLANG10]

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