Chris Webb has a follow-up to a prior post:
My post earlier this year on enabling query folding when using SQL queries as a data source in Power Query provoked a lot of interest. This post adds one more useful detail: how to preserve the original data types of the columns in your query when using this technique with SQL Server-related sources.
Read on for an example using the DATE datatype.