Federated dataset: can I prevent a non-filtered preemptive query?

JohnKalan_HITRUST

I am using a federated dataset (SQL Server) with hundreds of millions of records, for thousands of users. It appears that Domo retrieves or queries the entire data set before any card is displayed, resulting in tremendous resource usage. When a user views the card, I am providing a filter that restricts the query to one user via WHERE clause, and the query is much faster and less resource intensive.

Is there a way to prevent the non-filtered call to the dataset? I have already tried setting TTL to zero (0).