Multiple Queries that build on one another, do I have to refresh them in order?

[10500438]

I have one workbook with 10 different queries, some of the queries are referenced off of other queries. Some are duplicated queries but filtered down to get the first and last record connected to a transaction.

Do I have to refresh the queries sequentially in order for the referenced queries to update correctly?

[AlB · Accepted solution]

Hi @10500438 

No. Refreshing Query1 will automatically trigger the refresh of whatever dependencies QueryA has. It's necessary to accomplish the refresh of QueryA and PQ will do it on its own (it wouldn't otherwise be able to generate a refreshed QueryA)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers