Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Bind to parameter is missing in modelling advanced properties for parameter

This is the desired screenshot.  But when we are trying to open the same window we cannot see this.  Power version installed is : 2.100.684.0 64-bit (December 2021). Let us know more updates...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Amit,

     

    I'm from Sahana team we import data using sharepoint excel file. Since the file name is changing weekly we decided to create parameter and implement it as a M Query in Advance query editor. to access the created parameter in Modeling tab Advance property we are unable to see Bind to parameter option.

  • MacBI's avatar
    MacBI
    Regular Visitor
    1 year ago

    Hello,

     

    I am using direct query and the option still refuses to appear. 

    Photo of my parameter:

    Here is my M query that is DirectQuery that calls the Param:
    let
    LearnerChart = #"LearnerChart",
    SQLQuery =
    "SELECT * FROM [dbo].[ReportLinks] WHERE 1=1 AND URL = '" & LearnerChart & "'",
    Source = Value.NativeQuery(Sql.Database(SqlSserver,SqlDB), SQLQuery)
    in
    Source

    Then I created my table of values for the binding process but it still isn't there. Here is an image showing my direct query table and the table I made to store the values in showing no bind option...

     

    I followed the guide you linked step by step. Thoughts? I really am at a loss here.....