Load From Source File Only Once In Query Chain

[Cscullio]

I have a query that loads all the data from an access table (Query1).

I then have another query (Query2) which aggregates data from Query1.

I then have another query (Query3) that aggregates data from Query2.

My problem is that whenever I refresh, all three queries try to connect to the Access database at the same time and I get an error.

Is it possible to create a query chain like this that only loads data from the Access database into memory once (Query1) and Queries 2 & 3 only run from the in memory Q1?

[v-chuncz-msft]

@Cscullio,

Based on my research, you might need to retain only one query in Query Editor, and perform aggregation operation in DAX.