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")...
If you really want to use DirectQuery, you might want to create a view in your source (Spark SQL I guess?) and do the anti join there. Also, If you're using DirectQuery you might want to limit the number of visuals on a single report page...