Forum Discussion

ajlind25's avatar
ajlind25
Copper Contributor
May 16, 2026

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...
BI & Data Analysis
excel
Olufemi7's avatar
Olufemi7
Steel Contributor
May 19, 2026

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

ajlind25's avatar
ajlind25
Copper Contributor
May 19, 2026

Hi Olufemi7​ . Thanks for the response. I am not familiar with a parallel loading setting in Excel and I can't see it when following your instructions. I have tried everything else you described. Unloading queries would break our workbooks.