Forum Discussion

SteBr's avatar
SteBr
Regular Visitor
5 years ago
Solved

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 examp...
Need Help
  • SteBr's avatar
    SteBr
    5 years ago

    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?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Can you provide screenshots of the parameters created, the transformation page, etc. anything? 

     

    Its a fairly new feature, so bugs are unfortunately expected. For example, the recipe for binding parameters are exact...but sometimes i have to delete it and re-create it and voila - it works again. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      I have two Query sources, both are using the same SQL table. One is our query used for the report and the for the other, only one column was kept the others deleted for the filter data.

       

      Below - Bolded in the Advanced Editor script is the Parameter that is used to populate the Data.

      Then, the parameter

       

      The column of data used for the parameter 

      Where we should see the Binding Parameters selection, but don't

      No Preview Features menu to select the M Query Dynamic Parameters option

      Please let me know if you need any more information. Thank you for responding!!