Forum Discussion

Jacek321's avatar
Jacek321
New Member
2 years ago

How Power Query for excel works with reference query

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

Need Help

1 Reply

  • BA_Pete's avatar
    BA_Pete
    Super User
    2 years ago

    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