Forum Discussion
Dataflow Gen2 execution of chained queries and caching
In DFGen2, if i have a query (call it Query1) that is used by several other queries, will Query1 be executed each time the other queries are run or will the results from the first call be reused by the other queries? Does the behaviour change if Staging is enabled/disabled?
It depends. For the staged queries, once the query is staged the subsequent queries will simply reference the staged data as mentioned in the articles shared.
For other queries, it relies on how they're being evaluated as well as the privacy / firewall partitions set by the privacy levels. The best articles that I can share to answer the question on how things are being evaluated by the Power Query engine are the ones below:
- Understanding query evaluation and query folding in Power Query - Power Query | Microsoft Learn
- Query folding examples in Power Query - Power Query | Microsoft Learn
- Query folding indicators in Power Query - Power Query | Microsoft Learn
- Query plan - Power Query | Microsoft Learn
Particularly the query plan is the one that will help you the most to understand how your query will be evaluated. It could be that you have 10 queries, but all of them result into a single native query to your data source due to the query folding of the data source and the connector taking place, so looking at each of them separately would not be the best way to look at things. Its because of this that the answer really is "it depends" and I hope that the articles mentioned above help you understand better how your queries are being evaluated.
If you want to force a query to be evaluated once and subsequent queries to simply reference it and take advantage of the query that was computed, the most explicit way to do so is to take advantage of the "staging" mechanism described in previous articles shared. There are other ways to do so, but the one recommended by the Product Group is to leverage the Staging mechanism.
6 Replies
v-cboorla-msftMicrosoft Employee
Thanks for those and i had seen them previously. What they do not answer is my question of "if i have a query (call it Query1) that is used by several other queries, will Query1 be executed each time the other queries are run or will the results from the first call be reused by the other queries?" I do understand if the data is staged, then it "probably?" wont be run each time...but how about for unstaged?
- miguel
Community Admin
It depends. For the staged queries, once the query is staged the subsequent queries will simply reference the staged data as mentioned in the articles shared.
For other queries, it relies on how they're being evaluated as well as the privacy / firewall partitions set by the privacy levels. The best articles that I can share to answer the question on how things are being evaluated by the Power Query engine are the ones below:
- Understanding query evaluation and query folding in Power Query - Power Query | Microsoft Learn
- Query folding examples in Power Query - Power Query | Microsoft Learn
- Query folding indicators in Power Query - Power Query | Microsoft Learn
- Query plan - Power Query | Microsoft Learn
Particularly the query plan is the one that will help you the most to understand how your query will be evaluated. It could be that you have 10 queries, but all of them result into a single native query to your data source due to the query folding of the data source and the connector taking place, so looking at each of them separately would not be the best way to look at things. Its because of this that the answer really is "it depends" and I hope that the articles mentioned above help you understand better how your queries are being evaluated.
If you want to force a query to be evaluated once and subsequent queries to simply reference it and take advantage of the query that was computed, the most explicit way to do so is to take advantage of the "staging" mechanism described in previous articles shared. There are other ways to do so, but the one recommended by the Product Group is to leverage the Staging mechanism.
- v-cboorla-msft
Hi tdenbow
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.
