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?

SteBr's avatar
SteBr
Regular Visitor
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?

  • DaveHowe's avatar
    DaveHowe
    Regular Visitor
    5 years ago

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

     

    Thanks,

     

    Dave

    • kjerez's avatar
      kjerez
      Frequent Visitor
      5 years ago

      Did found an answer for this?

      • SteBr's avatar
        SteBr
        Regular Visitor
        5 years ago

        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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    "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

     

  • kjerez's avatar
    kjerez
    Frequent Visitor
    5 years ago

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