Press "Enter" to skip to content

Preserving SQL Data Types when Query Folding

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.