Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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.

 

 

10 REPLIES 10
wellvictor
New Member

wellvictor_0-1691832480177.png

Dynamic m query feature not showing in preview features. inside model view=>Properties of Date column => Advanced => Bind to Parameter option not visible please help

wellvictor_1-1691832826677.png

inside model view=>Properties of Date column => Advanced => Bind to Parameter option not visible please help

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 🙂

Hi,

 

This is not working.
I am using Direct Query to fetch data from MySQL database. I dont see the option to bind parameter.
Would you know any other way to do this?

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!

Anonymous
Not applicable

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 !

Anonymous
Not applicable
v-angzheng-msft
Community Support
Community Support

Hi, @Anonymous 

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors