09-05-2018 11:57 AM
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.
The query steps can be summaried as follows:
- Connected to source
- Renamed columns
- Extracted values from column list
- Extract values from column list
- 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?
09-06-2018 12:51 AM
The following article lists some useful tips.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.