•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Power Query refresh speed with multiple users
Our take
Hello everyone, I’m seeking insights on improving Power Query refresh speeds for a report with multiple SharePoint data sources. While most users experience refresh times of 5-10 minutes, two of us are facing delays of 30-60 minutes despite enabling Fast Data Load for all queries. I've optimized the initial code and cleaned up old data files, but the improvements have been minimal. Given that all users share the same laptop configurations and internet connection, what additional steps can I take to enhance query performance?
Hello all.
I have a report that has multiple queries with data sources saved in SharePoint. Enable Fast Data load is checked in all the queries.
There are about 10 users, with reported run time of around 5-10 minutes. But for me and one user, it takes 30-60 minutes to finish refreshing.
I have already made some improvements in the initial code, and did a clean up of old raw data files in SharePoint but this resulted to minimal improvements.
Given that all users have the same laptop configurations and are connected to the same internet connection, what are some steps I can do to do improve the speed on the queries?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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]
- PowerQuery and add manual dataHi everyone, I have a Power Query in Excel that outputs a table with [title] [date]. I need to manually add the Sprint number in an extra column [sprint] to specific combinations, aka "I will work on this this month." The problem is every time the query refreshes, any manually entered data gets lost or misaligned. - New rows come with the needed values. - Row order changes. Because this table is used by many people, I want them only to add the sprint number, nothing else, no copying data or anything. I would like to know more about your experiences when data needs to be written infrequently but many times. I am open to know more for powerbi options direct dashboard too. submitted by /u/No_Solid2349 [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]