•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Power Query Refresh Time
Our take
When working with a Power Query product database in Excel, refresh times can vary significantly among users, even with identical files and data. In this case, the author experiences a refresh time of about 20 seconds with 50 rows, while coworkers report refresh times of approximately 2 minutes. This discrepancy raises important questions about potential factors influencing performance, such as local settings, system resources, or network conditions. Understanding these variables can help optimize refresh times for all users and enhance overall productivity.
I 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?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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]
- 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]
- Power query and manual table next to itHi, I want to pull data verbatim from a spreadsheet my team uses and use data from it for my own purposes. The main goal for using power query is that the data updates on my spreadsheet. Mainly, if any new entries are added at the bottom. I also have some manual fields that I need to add that correspond with the power query data. I've added another table beside the power query data, and filtering it causes the data on both sides to adjust correctly. I'm mainly concerned that, if the entries are rearranged or sorted on the original sheet, that my tables will not align after a refresh. Also, if a refresh would break my table alignments at any point. Is my fear founded? Is there a way to combine the two features that I need into a single table? submitted by /u/Perspective-Guilty [link] [comments]
- Power Query Merge Issue - Duplicate Tables After Refresh?Hi everyone, I have two Excel sheets, each containing a table. I’m using Power Query to merge them into a new table (Merge query), and everything works fine initially. However, after I load the result back into Excel, I notice something odd: The merged sheet (called "Merge") is created correctly. But the original two sheets seem to get duplicated again as separate tables (like "Table1" and "Table2"). My main concern is this: I regularly update the data in the original two sheets. So my questions are: Will the merged query automatically reflect updates from the original sheets when I refresh and where to but the new data in the orginal sheets or the new table 1 and table 2? Or do I need to set up something specific to make sure the merge stays updated? Also, is it normal for Power Query to create duplicate tables when loading, or am I doing something wrong? Any clarification would really help. Thanks! submitted by /u/Resident_Quantity827 [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#financial modeling with spreadsheets#rows.com#real-time data collaboration#natural language processing for spreadsheets#big data management in spreadsheets#conversational data analysis#Excel compatibility#intelligent data visualization#data visualization tools#enterprise data management#big data performance#Excel alternatives#data analysis tools#data cleaning solutions#enterprise-level spreadsheet solutions#real-time collaboration#Power Query#Excel