How Power Query for excel works with reference query

[Jacek321]

Hi,

I have question about how Power Query in Excel working with reference query? If I created query and then use it as reference for two other queries, is system processing all three queries separately (from source to the result dataset) or using results from first query as a source for two reference queries.

Thanks in advance for information.

Jacek

[BA_Pete]

Hi Jacek,

In almost all cases (I think there's a few edge-case exceptions) Power Query will query the source for every query, regardless of whether it is a reference of another query or not.

Pete