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
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.....