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.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.