Power BI - Dynamic M Query Parameter binding not shown

[SteBr]

I have the same problem as described in here, the only difference is, that the proposed solution (restart Power BI ) does not work. 

I've copy&pasted everything (query and structures) from the example in the blog entry. 

- Version is: 2.86.902.0 32-bit (Oktober 2020)

- Feature "Dynamic M Query parameters" is activated in "preview features"

- Parameters are created (date/time) 

- Parameters are used in the query - query itself works perfectly

- Tables are created according to the blog post

- Slicers / Filters are created

--> still the dropdown "Bind to Parameter" is not shown in "Field" - "Properties" - "Advanced" section, the shown fields are only "sort by column", "data category" and "summarize"

preview featuresfield properties - advancedm query

[SteBr · Accepted solution]

I've found the root cause by myself: the query type was not (automagically) set to "direct query".

After setting up everything manually I could finally see the parameter binding option. 

@DaveHowe maybe this could help you as well?

[kjerez]

Hi! can expand on this, I did not understand the part of setting manually. Thanks

[DaveHowe]

Thanks, but I don't think I understand what you mean.  What did you set up manually?

Thanks,

Dave

[kjerez]

Did found an answer for this?

[DaveHowe]

I am experiencing the same problem.  I have the preview feature enabled, date type parameter created and referenced in M Query, date table created, but the "Bind to Parameter" is not available.

[v-zhenbw-msft]

Hi @SteBr ,

What data source are you connecting?

Please check the Considerations and limitations.

Please check the steps in this document.

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

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.