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")...
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.