•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
PowerQuery Opens Files on Refresh
Our take
If you're encountering unexpected behaviors with PowerQuery, like multiple files opening randomly during refresh, you're not alone. This frustrating issue can disrupt your workflow, especially when you're simply trying to pull data from a few documents without complex transformations. While you've successfully used PowerQuery for years, this recent glitch may stem from a software update. In this discussion, we’ll explore potential causes and solutions to streamline your experience, ensuring that your data refreshes without the hassle of opening unrelated reports.
I've been using PowerQuery for a couple years now and have never experienced this issue.
For context, this query wasn't complex to begin with. It loads one tab from 20-30 documents found within a folder on a shared drive. No transformations to the raw data, other than promoting headers. Even recreated the document from scratch while troubleshooting.
Whenever I go to Refresh in the document, it begins opening reports from the folder at random. Doesn't appear to follow a pattern, just randomly. Not all of them, just whichever ones it feels like opening.
It does eventually refresh but takes forever and I have to close out of 10-15 reports while it does. It will also begin opening documents while I'm editing in PowerQuery and prompt that I cannot close the window while in PowerQuery.
Is this a new bug during an update? I've never experienced this before.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- PowerQuery hangs forever in refresh when multiple computers are used to editI'm having a sudden problem in which when I make edits on another computer and try to refresh PowerQuery on my primary computer, it refreshes forever or sometimes refreshes for hours before throwing up a random memory error. Normally, the refreshes take between 3 and 10 minutes. I've used this setup for a year now with no issues before last week. I have an relatively elaborate PowerQuery setup that pulls in shared data from many sources, including online, Dropbox, SharePoint, OneDrive, and in-workbook excel tables. Lots of merges, lots of custom formulas. All file locations are variable parameters that are changed via a dropdown in Excel. I do most of my work on an up-to-date Windows 11 version of Excel running on a Mac via Parallels. The other machine I occasionally edit on is another up-to-date version of Excel on Windows 11. They are synced via Dropbox. At first I thought my VM was corrupted, so I reinstalled fresh. It worked fine until the next time I edited on another machine. I've deleted all PowerQuery and Excel caches and it still happens. Nothing I'm doing is new, so I'm not sure why it suddenly breaks. Any thoughts? submitted by /u/WorldsGreatestWorst [link] [comments]
- Have you encountered some users who can't refresh Power Query?I’m running into a Power Query refresh issue in Excel that I haven’t been able to resolve through Googling. We have an Excel file with Power Query connections that a team uses to refresh and pull updated data. The file is stored in a shared Google Drive folder, and both teams involved have the same access permissions. Here’s the issue: One team is able to refresh the queries without any problems. Another team receives errors when trying to refresh, with error messages that the source file cannot be found or that columns are missing. Additional context: We are all using Microsoft 365. Permissions appear to be identical across both teams. I am able to refresh the file successfully without errors, so are other people within my team, so obviously not a source file issue. I’ve created other Power Query–based Excel files in the same shared folder, and the affected team can refresh those without any issues. The problem seems isolated to this specific file. Has anyone encountered this issue before? Has anyone resolved this issue before? My last ditch effort would be to just recreate the whole thing and see if that fixes it. Here's the error message if you're interested. It doesn't help: https://i.imgur.com/Gss7SHt.png submitted by /u/TheRiteGuy [link] [comments]
- Power Query Refresh TimeI created an Excel file with a Power Query product database. It takes item-level data (sizes, colors, logos, etc.) from an Item Master, expands it into all SKU combinations, and builds out a final product database with pricing and item info. It also pulls in a predetermined product codes from a separate tab with 300,000 rows. When I refresh the file (both at home and at work), it takes about 20 seconds with 50 rows. I had a couple coworkers try the exact same file, and it takes about 2 minutes for them to refresh. It is the same file, same data, same network, and similar computers. I can’t figure out why it’s consistently faster for me than everyone else. Any ideas of what could be causing this? submitted by /u/Presto1985 [link] [comments]
- Excel Power Query refresh suddenly incredibly slowHi everyone, I have a file that I refresh daily with several queries. One of those became incredibly slow (few seconds to hasn't finished yet) from one day to the next. Nothing changed in the file or source, it is not very large (~5000 lines) and without any manipulations other than changing the data type. I have tried to change the privacy levels, background refresh, fast load and so on as I found online, but nothing helped. How can I solve this? Thank you! submitted by /u/Loose_Biscotti9075 [link] [comments]