This story from a PowerQuery user is not just a bug report. It is a clear signal that the tool is failing at its most basic promise: to make data retrieval reliable and predictable. When a refresh command starts opening random files from a shared folder, the system is no longer serving the user, it is fighting them.
What makes this especially telling is the simplicity of the query involved. The user is not asking PowerQuery to perform complex transformations or merge dozens of sources. They are pulling one tab from 20 to 30 documents and promoting headers. That is a workflow designed to be straightforward. The fact that the tool responds by opening ten to fifteen unrelated reports, with no discernible pattern, means the core engine has lost its sense of purpose. A refresh should be a single, clean action. Instead, it becomes a cleanup operation where the user must manually close windows while waiting for the query to finish. Worse, the interference continues even when editing inside PowerQuery itself, locking the user out of their own work.
We see this as a symptom of a deeper problem. Tools like PowerQuery were built for an era when data was static and local. But the reality today is that data lives on shared drives, in folders, and across multiple sources. The old architecture is cracking under that weight. When a refresh action behaves randomly, it is not a minor glitch, it is a fundamental lack of control. The user did everything right: they recreated the document from scratch, they kept the query simple, and they still cannot trust the tool to do what it is told.
For anyone relying on PowerQuery for daily work, this is a warning. You can spend hours troubleshooting, rebuilding queries, and closing rogue documents, but the underlying fragility remains. The solution is not to work harder within the tool's limits. It is to find a platform that treats data as a fluid, accessible resource, not a collection of files that decide to open themselves. A truly modern approach should let you define a source once, refresh with a single click, and never wonder which documents will appear on your screen. That is the standard users deserve, and it is the standard we believe the next generation of spreadsheet tools must meet.