local evaluation of TableJoin or table.nestedjoin with key equal compareres is not supported

Hi rohit1991 
I have a multiple table in my semantic model and also there are lot of transformations applied in the power query, so it's very hard to trace where the issue is coming from. I had to test with each and every scenario to find out the poroblem which might take lot of time. Is there any way to troublehsoot the issue where the actual issue is coming from. Because the error message is very generic, if we know it's because of specific table that would be easy to work on fixing the issue.

Also the semantic model is in Direct query & Dual mode which is basically of Composite model. There are multiple reports based of this semantic model but YOY calculations are created at each report level.