topic Re: How to prevent Direct Query from running on every filter change for Direct Query App in App Development

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

conconmcmc — Tue, 11 Mar 2025 15:52:02 GMT

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)

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

Chanty4u — Wed, 12 Mar 2025 02:58:07 GMT

You can

Aggregate Data Before Query Execution only

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

conconmcmc — Wed, 12 Mar 2025 16:53:12 GMT

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.