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?

[SteBr]

@kjerez @DaveHowe The data source in my testing environment doesn't support directQuery, that was the root cause. You can find a list of supported data sources here: https://docs.microsoft.com/de-de/power-bi/connect-data/power-bi-data-sources

I'm using text/csv at the moment so I can't make use of dynamic m query parameters at the moment. 

With setting up manually I was referring to the step-by-step example shown in the blog post . When I tried this (including the GitHub demo data source everything was working as expected. 

[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.

[Bella42]

Why do they release 'features' that are so lame? There's hours of my life I will never get back. Yes, I should have intuited by now that anything PowerBI related would not be fit for purpose, and read the 'considerations' first. I know now to always read the fine print and expect NOTHING. Yes, I am a disgruntled  ex-VBA/Excel user.

[jtorresoTCC]

Hello!
I would like to ask which could be a workaround for this issue?

tks