Forum Discussion
Excel Power Query: editing unloaded query refreshes dependent queries
Hi all There has been a change between version 2601 and 2602 on the Current channel which means that when editing a query in Power Query it will trigger a refresh for all dependent queries. This mak...
Hello ajlind25,
Based on your testing, this does appear to be a behavioral change introduced around Current Channel version 2602.
Previously, editing an unloaded staging query typically did not refresh dependent loaded queries during Close & Load. In newer builds, dependency evaluation appears to occur more aggressively.
I am not aware of any published Microsoft documentation confirming whether this is intentional or a regression.
A few things you can try:
- Disable background refresh in Query Properties
- Disable parallel loading under File > Options > Data
- Keep intermediate queries as Connection Only
- Temporarily disable downstream loads while editing staging queries
- Test Monthly Enterprise or Semi-Annual Enterprise Channel builds
I would also recommend submitting feedback with:
- exact build numbers
- repro steps
- whether the issue occurs in a new blank workbook
Current Channel release notes:
Microsoft 365 Current Channel release notes