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

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

Explicit data type conversion is specified in terms of SQL data type definitions. The ODBC syntax for the explicit data type conversion function does not restrict conversions. The validity of specific ...