I have a model I built with Power Query in Excel. The thing takes forever to refresh and with extremely small amounts of data. I feel it may be because of some of the relationships among queries that I set up but I am not sure how to attack trying to figure out why/where it is so slow. Does anybody have suggestions for analysis?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Power Query Excessive Time to Refresh
- Thread starter MikeDBMan
- Start date
-
- Tags
- slow refresh
Excel Facts
Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
jdellasala
Well-known Member
- Joined
- Dec 11, 2020
- Messages
- 755
- Office Version
- 365
- Platform
- Windows
- Mobile
- Web
Try to figure out what line is causing the slowdown, and before that line add the code
Power Query:
Table.Buffer(PreviousStep)
Upvote
0
Similar threads
- Question
- Replies
- 1
- Views
- 132
- Replies
- 2
- Views
- 615
- Replies
- 3
- Views
- 2K
- Replies
- 2
- Views
- 1K
