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 ...

Learn about SQL Server data type compatibility and implicit and explicit conversion. When you convert between an application variable and a [!INCLUDE ssNoVersion] result set column, return code, ...

A relational database table is articulated on a fixed number of columns and each column has its own data type, such as strings of variable or fixed length, dates, numbers, Booleans and the like. JSON ...

To learn more about SQL data types, read “SQL basics: String data types, ... (UTC), where 00:00:00 represents midnight in Greenwich, and the server’s local time zone is implied.