How to prevent Direct Query from running on every filter change for Direct Query App

[conconmcmc]

Hi Folks

We are trying to use direct query to query a larger partitioned table in BigQuery. We would like for the base app to not always update each time a filter is changed and to have default filters to prevent full table scans on the Bigquery table when users interact with the App.

I know you can limit the row count on detailed view from ODAG, but we would just like the ability for the base app to already have a filtered view and reduce the amount of queries sent to BQ (so they aren't sent on each filter change)

[Chanty4u · Accepted solution]

You can 

Aggregate Data Before Query Execution only 

[conconmcmc]

Yeah I have had a look, can't find anything. Annoying it would be good if you could have a default filter on the summary app but it seems you can't.