It’s surprisingly easy to stop query folding happening in Power Query by changing the data type of a column. This is mentioned in the docs here, and it’s something several people have blogged about ...

Column names in the SQL server database will match item names in the CSPro dictionary The items used as id-items in CSPro will correspond to columns appearing in each table in SQL server, with the ...

In a previous TechRepublic column about SQL Server 2005, I showed how you can convert some of your iterative queries (cursors) to set-based operations in order to enhance performance.