•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Power Query Refresh Time
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]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com