I don’t think this will work, but for giggles go into your BAQ and go to Actions > Execution Settings and add a new line for RemoveTestRowLimit and set the value to true.
If you’re in the new UX, you’ll have to hunt for it a bit as I’m not sure where it is off the top of my head.
This is the purpose of the “RemoveTestRowLimit” Execution Setting I mentioned earlier. Use at your own risk, however, because you’ll have a bad day if you create a query with hundreds of thousands of rows.
Our issue was a little different, even in BAQ designer and setting “RemoveTestRowLimit” to TRUE was only returning 10rows. I looked at our ticket in EpiCare but they didn’t give details on what they did on the back end.