MySQL Query Folding problem when changing datetime to date (dataflow)

[michaelsh]

I am connecting to MySQL from dataflow.

I have a date column the is datetime type (always contains 00:00:00)

When I change it to date type, my query folding breaks.

Why and how to get agound it?

[Anonymous]

Replace Table.TransformColumnTypes with Table.TransformColumns and replace type text with Date.From.

--Nate