Direct Query Field Property Missing "Bind to parameter"

[danyeungw]

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.

[danyeungw]

I cast the ReportDate to string. The Bind to parameter appeared. Thanks again.

[danyeungw]

Thanks @amitchandak. Is the data type caused the "Bind to parameter" missing? Thanks.

[amitchandak]

@danyeungw , Please check this in limiatation

If your parameter is the Date/Time data type, you need to cast it within the M query as DateTime.Date(<YourDateParameter>)

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters#considera...