Forum Discussion
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 featuresfield properties - advancedm query
17 Replies
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.
I have stepped through the document via the link in this post. I am not able to see the Binding Parameters selection as many are not. First, it's my understanding that I need to use Direct Query mode for all of my data. When I create a table for the parameter list using a table to enter the data instead of creating a filter from a SQL table, it want's to switch me over to Import Mode and that doesn't work. Your demo/example and many others create tables. How are they getting around the Import Data issue? Now, with that said. I don't have preview features to set the M Query Dynamic Parameters new feature. It's 10/2022 and we have a May 2022 64-bit edition, but we are running from a report server, not the cloud. Should that be an issue and the reason I still don't see the Binding Parameters option? My data types are all the same, so that isn't an issue for me. We really want to be able to use this feature, but I just can't figure out what we need to do to get it to work?
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.
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've found the root cause by myself: the query type was not (automagically) set to "direct query" - yes. this is true. I've discovered it too. Bind to parameter opion will NOT be available due to the presence of any non-Direct-Query Query. After I removed the "Calendar = Calendar(date(2021, 1, 1),TODAY())", the Bind to parameter option appeared under advanced. Of course, "File - Options and Settings - Options - Global - Preview Features - Dynamic M Query parameters" must be enabled as well.
I found that after I've removed the table (Calendar = Calendar(date(2021, 1, 1),TODAY())), the Bind to parameter option appeared under advanced. Thereafter, I can put back the calendar table with the Bind to parameter option remaining visible
Hi! can expand on this, I did not understand the part of setting manually. Thanks
This is Deborah from yesterday. I found someone that has the options I'm looking for. He said I should have the Pro app and need the Premium license and then he uses Workspaces. I don't understand how his development is different. Would it be? Isn't Workspaces just storing the reports in a different location than Report Server, which is what we use. He thinks that maybe our Workspaces are old and not Premium? My personal Workspace is premium (has diamonds next to file names). How do I open one of these in desktop and get difference options? We have been doing everything the same for almost 2 years, so I'm not sure how Workspaces comes into play and why it might cause us not to have the Query M Dynamic Parameters options he has. If you can provide me with info to clear this us or help me understand I would appreciate it.
