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 features
field properties - advanced
m query
Solved! Go to 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?
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?
Hi! can expand on this, I did not understand the part of setting manually. Thanks
Thanks, but I don't think I understand what you mean. What did you set up manually?
Thanks,
Dave
Did found an answer for this?
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.
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.