Forum Discussion
Solved
Passing a Date/Time Variable inside a SQL Query in Dataflow Advanced Editor
I want to load data daily from MySQL to Fabric Lakehouse using Dataflow. My technique is to get the maximum DateCompleted and get the data from MySQL bigger than this value. I have 2 queries in my ...
Date.ToText - PowerQuery M | Microsoft Learn
Make sure you format the text correctly. Ideally that should be in ISO-8601 format.
Your closing double quotes are in the wrong place too.
Change
date_completed " > & MaxDateCompleted ])
to
date_completed > "& MaxDateCompleted ])
--Nate