Forum Discussion
Start and End Date Parameters for SQL statement in Import mode
Sorry for the late reply. Hopefully you managed to figure it out, but if not then you need to go into the Model view, then bind the column to a parameter. Please note that this will only work in you have Direct Query connection. And ONLY Direct Query. If you have a mix of SharePoint, or anything else, it won't be available.
peterg0417
I was able to get the Paramaters to work with the following before the Query
StartDate = Text.From ( StartDateParam ),
EndDate = Text.From ( EndDateParam ),
& this in it
WHERE (h.Date_Entered_dt >= N'" & @StartDate & "' and h.Date_Entered_dt <= N'" & @EndDate & "' )
This is great! How can my Start date and End Date Slicers update those paramaters like they do with the Direct Query?
Sorry for the late reply. Hopefully you managed to figure it out, but if not then you need to go into the Model view, then bind the column to a parameter. Please note that this will only work in you have Direct Query connection. And ONLY Direct Query. If you have a mix of SharePoint, or anything else, it won't be available.