Forum Discussion
Query Download Size Increased 6x - Why?
Good afternoon. I'm have a workbook setup to pull data from a list in SharePoint. Based on some additional requirements, I decided to develop a new version from scatch so I could setup the data a little differently, and make different relationships. Previously, when I conducted a refresh on the query, it was around ~35MB and took about 5 minutes. Now for some reason it's around 220MB+ and can take 30 or more minutes to refresh.
The added download size doesn't really affect the workbook size, but it's simply taking forever to pull in updates/new content, and I have no idea why.
Any thoughts?
The query steps can be summaried as follows:
- Connected to source
- Renamed columns
- Extracted values from column list
- Extract values from column list
- Sorted
- Added Index value
- Removed (~20) irrelevant columns
Is the sequence I have setup causing more data to be pulled down than I need? Should I try re-ordering or removing steps?
1 Reply
The following article lists some useful tips.
