How to avoid unnecessary query invokations?

[Anonymous]

I have a query that fetches the full dataset and a bunch of queries that references this query and adds different filters.

When refreshing it will make the same fetch for all queries, both for the full data and all referenced queries.

Is it possible to make it so that it only makes the fetch for just the full data query and that this dataset is then used by the queries that references it, instead of making the same fetch for every single query?

[mahoneypat]

You can probably address that by turning off parallel loading of tables.  Please see this video to explain further.

(2) Inside Power Query reference queries for Power BI and Excel - YouTube

Pat

[Anonymous]

Let's say I have queries A and B. A has it's source an ODBC connection to Amazon Athena.
B has as it's source a reference to A and then some additional filters.

When refreshing, both A and B will each cause a fetch to AWS and get the same data set. I would rather only have A make the invokation and B would then "reuse" the dataset instead of making its own fetching of the data.

Hope this makes it clearer.

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
You can right click on the table and refresh one table at a time.
Appreciate your Kudos.