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. Consider the DimDate table in the ...

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

Having a sql server table with a column image data type is not mapping to SqlBinary and only maps to byte[]. Create a database using Northwind sql-server-samples Use the following code to retrieve ...