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.