Forum Discussion
Advocate VPower Query Terrible Performance
I am working with 250K rows of data - nothing fancy
Everything is moving quick but when I do a couple of Merges - that's it!
About 50% of the time I spend on project is waiting for Power Query.
Even AFTER the Merge / Expand Step is finished - all sequential steps (even simple Add Column with if calculation ) - they take forever. Is is calculating all over again!!!
An I don't have any cartesian joins - only simple one-to-many merges.
A nightmare!
Once it passed the merge/expand - It shouldn't rerun all the next steps again.
How to do this? Any ideas?
Hi michaelshparber ,
Have you checked out the points from this list?: https://www.thebiccountant.com/speedperformance-aspects/
3 Replies
- Greg_Deckler
Community Champion
This sounds like something that ImkeF might be able to help out on.
- ImkeF
Hi michaelshparber ,
Have you checked out the points from this list?: https://www.thebiccountant.com/speedperformance-aspects/
michaelshparberGreat, thanks, I already see some things that I do, like Grouping...
I'll definetely check it out, thanks!
