cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SteBr
Regular Visitor

Power BI - Dynamic M Query Parameter binding not shown

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 featurespreview featuresfield  properties - advancedfield properties - advancedm querym query

1 ACCEPTED SOLUTION
SteBr
Regular Visitor

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?

View solution in original post

9 REPLIES 9
SteBr
Regular Visitor

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?

View solution in original post

kjerez
Frequent Visitor

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

DaveHowe
Regular Visitor

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

 

Thanks,

 

Dave

kjerez
Frequent Visitor

Did found an answer for this?

SteBr
Regular Visitor

@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
Regular Visitor

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
Community Support
Community Support

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.

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.

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

tks

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!