•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Why does power query crash after loading
Our take
Experiencing crashes in Power Query after extensive transformations can be frustrating, especially when your workbook runs smoothly initially. This issue often stems from resource management—Power Query may be struggling with memory allocation or background processes that continue to run even after loading is complete. Understanding these underlying factors can help you optimize your workflow and prevent future disruptions. In this exploration, we’ll delve into common causes of Power Query crashes and offer actionable insights to enhance your experience and boost stability.
I have a power query workbook that does quite a few extensive transformations (takes a minute or so to load)
But then is fine
But sometimes like 20 mins later the file crashes despite not actually running anything anymore
Why does this occur?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Excel file crashes when checking a segment's boxHello everyone, I'm on excel 2016 and I have an excel workbook with a database of around 2000 rows and 20 columns, 4 tables extracted with PQ each one in a sheet, 7 or 8 pivot tables referencing these queries with the same number of graphs. Sometimes (not every time) the file crashes and reloads itself when I click on a button on a segment and it's frustrating. What could cause that and how can I improve my file? submitted by /u/fluctuatore [link] [comments]
- 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]
- Excel - Get Data - Access stuck on "Loading Data..."I have a workbook with multiple queries that pull data from Access queries and load to pivot tables. Most of them update/refresh fine, but several of them just spin and get stuck on "Loading data..." The query results are only like 10-20 rows for each of these that get stuck. The power query does no filtering/sorting or anything, I have no VBA doing anything, no macros, or conditional formatting. I'm clueless as to why some are fine and these others just get stuck. Help!!! TIA. submitted by /u/Good_Struggle_7471 [link] [comments]
- Does power pivot refresh in sync with power queryI have a file that had an extensive power query transformation And I essentially need to make a few different pivot tables using the PQ output to summarize some results But I’m concerned that if I do that the pivot table will refresh before the power query output refreshes If I use power pivot (which im unfamiliar with) Will this issue be avoided I could just use power query to get the results I need in the desired format but my system is 32 bit and that would murder the memory since I’d have to run the same query 3-4 times and as I understand it power pivot is much easier on the memory for visualizations submitted by /u/Falconflyer75 [link] [comments]