Forum Discussion

ReadTheIron's avatar
ReadTheIron
Icon for Helper III rankHelper III
2 years ago

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")...
Need Help
sjoerdvn's avatar
sjoerdvn
Icon for Solution Sage rankSolution Sage
1 year ago

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