Forum Discussion
Power Query Performance
Thanks for the flowers AlexisOlson but I'm no Power Query expert by any stretch. I am currently re-reading the utterly fantastic primer on Power Query by Ben Gribaudo
Power Query M Primer (part 1): Introduction, Simple Expressions & let | Ben Gribaudo
Ian_Stuart_Rupe I highly recommend you read the articles as well - all of them. You will be able to appreciate how Power Query actually works, what it is good at (hint: Counting rows is definitely not on the list, quite the opposite) and what differentiates it from other languages like SQL. The primer has an extensive section on keys and indexes and their influence on joins.
Here's a great video on the topic: How Power Query Thinks: Taking the Mystery Out of Streaming and Query Folding (Video) | Ben Gribaudo
Hi lbendlin I read (or at least skip read) all the articles. Some were new to me and very helpful. I did not see the artucle that addressed counting rows though?
I made the same mistake initially (skip reading the articles). Re-reading them slowly was time well spent. At the minimum you may want to rewatch the streaming video.
Understood but I have to cherry pick what I spend my time on. A lot of those articles are too deep and others I already know about. There are some gems in there too but I simply do not have time to search for hidden treasure at the moment. Suffice to say we all agree it is slow methinks 🙂
Ian_Stuart_Rupe are you on premium workspace ?
