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?

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