Since the August 2025 update it appears Direct Query connections cannot be selected when connecting to Dataflow Gen 1 sources. Any reports that were previously setup using Direct Query return the ...
Query Folding does not work at all against Gen 1 Dataflows. Surprised there is not a broader discussion about the failure. I hope this not going to take 3 months to find a fix