Forum Discussion
Can't use left anti join with DirectQuery
I have a very large table ("All Failures") I'm connected to with DirectQuery. I'm trying to filter these records so as to exclude the ones that appear on a much smaller list ("Disqualified Failures")...
I was afraid this would be the answer, since I am basing the entire report on "All Failures". The measure works to create it, but I'm not sure how to use it as a filter in the variety of visuals I'm creating based on the "All Failures" table. Thank you for responding though!
Hi ReadTheIron ,
Could you tell me if your issue has been solved? If it is, kindly Accept the helpful reply as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your issue.
Best Regards,
Rico Zhou
None of the proposed solutions helped; I ended up using Import instead of DirectQuery with a filtered table.