One of the really nice features of working with Power Query is the ability to have the tool translate your M language steps into native code in the backend for some data sources. This is called Query Folding, and MSSQLTips has a good introductory article on it, Query Folding in