Forum Discussion
Refreshing Just One query from connected queries
Hi justingraff88
Thank you for reaching out to the Microsoft Community Forum.In Power BI, when a query is refreshed, Power Query evaluates all dependencies. This means that if Query3 depends on Query1 and Query2, both queries will be refreshed before updating Query3, leading to longer refresh times due to query dependencies, as mentioned by lbendlin .
To optimize performance, consider using staged queries to store intermediate results instead of directly appending Query1 and Query2 into Query3. Power BI does not automatically refresh referenced queries unless explicitly required.
Keep Query1 and Query2 with "Enable Load" unchecked, create Query1_Staging and Query2_Staging as references with "Enable Load" enabled, and append them into Query3.
If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Thank You.
Hi justingraff88
Thank you for reaching out to the Microsoft Community Forum.
In Power BI, when a query is refreshed, Power Query evaluates all dependencies. This means that if Query3 depends on Query1 and Query2, both queries will be refreshed before updating Query3, leading to longer refresh times due to query dependencies, as mentioned by lbendlin .
To optimize performance, consider using staged queries to store intermediate results instead of directly appending Query1 and Query2 into Query3. Power BI does not automatically refresh referenced queries unless explicitly required.
Keep Query1 and Query2 with "Enable Load" unchecked, create Query1_Staging and Query2_Staging as references with "Enable Load" enabled, and append them into Query3.
If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Thank You.