Forum Discussion
danyeungw
Helper II
Helper IIDirect Query Field Property Missing "Bind to parameter"
Hello,
I created a ReportDate direct qeury table and ReportDateParam.
Select the ReportDate field, but the "Bind to parameter" is missing in the Advanced property.
From the Youtube video, It supposed to have
What did I miss? Thank you in advance.
3 Replies
- amitchandak
Super User
danyeungw , Please check this in limiatation
If your parameter is the
Date/Timedata type, you need to cast it within the M query asDateTime.Date(<YourDateParameter>) 
danyeungwThanks amitchandak. Is the data type caused the "Bind to parameter" missing? Thanks.
- danyeungw
I cast the ReportDate to string. The Bind to parameter appeared. Thanks again.
