cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Upasanasaini12
Frequent Visitor

Bind to Parameter Not Showing

Hi,

I have user sql query, Start date and end date.i try all below solution.

1.create a parameter then create a calaender table but in property -> advance option not show bind parameter functionality,

2.installed latest feb 2022 power bi desktop version but same issue is show,

3.Bind to Parameter Not Showing My Data Source is Sql Server Query.

In Sql query i have deaclare two perameter startdate and enddate and will get the data -> click sql server -> enter servername and database name -> database name side text and parameter two option is show -> click parameter and add parameter -> load data

but same issue is show,so can you help me how to fix it.

Thanks.

 

 

8 REPLIES 8
ChocoGanache
Frequent Visitor

Just add a datasource with DirectQuery (instead of Import) and then Bind to Parameter option will show up. At least this works for me, hope it works for you 🙂

This seemed to work: adding _any_ direct query into the model seemed to enable this field on fields in all the queries (imported or not).   Very strange...

Now if I could only get the binding to actually work!

sdclaudio
Regular Visitor

Hello,

This worked for me, but my case is slightly different, since the date I needed as a parameter is easily obtained using M functions and I'm using an OLAP query instead of a SQL one:
i) Instead of creating a brand new parameter through the Manager Parameters > New Parameter > etc, I created a New Query called "p_date", where I wrote the functions to obtain my date;
ii) Then, I selected the OLAP query, opened the Advanced Editor and replaced the (let's call it) fixed value by the p_date and ta-daaaaaaaaaa, it's done.

Would it work for you?

Ibra
New Member

Hello,

I have the same issue. I'm using Power BI Desktop for RS Jan 2022 version and i can't find preview features in options settings to enable Dynamic M parameters.

I also try to find it in Power BI Desktop May 2022 version, but impossible to see this option.

Any solution about this problem ?

Regards.

Senzo19
New Member

Hello,
i have the same issue. I can't see bind to parameter option in advanced settings.

i have Power BI Desktop for RS Mai 2021 Version.
Anyone have a solution ?
Regards !

Upasanasaini12
Frequent Visitor
v-angzheng-msft
Community Support
Community Support

Hi, @Upasanasaini12 

Would you consider attaching a screenshot to help us understand the issue you're having?


Best Regards,
Community Support Team _ Zeon Zheng


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I am having the same issue. There is simply NO "bind to parameter" option in Advanced Properties of the selected field -as shown in the screenshot above.

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Kudoed Authors