Forum Discussion
davidz106
Helper III
Helper IIIPower query optimization
I built a power query Parse function (this is a rather complex function with approx. 50 lines of M-code) which can parse my complex excel sheet. I have another query that: 1. returns a list of ...
ImkeF
Community Champion
Community ChampionHi davidz106 ,
there can be really many reasons. Please check out my collection of potential bottlenecks here: Speed/Performance aspects – The BIccountant
davidz106Helper III
Helper IIIThanks. I read the list. Step one and delayTypes are two things that could be beneficial to my case. My excel files are in range of 200-400kB so this is not really lightweight either.
Is there a tool I can use that would tell me a time needed to process a line of code (even inside of a function)? Maybe this way I could find a culprit easier.