Forum Discussion
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.
12 Replies
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!
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?
Hii,
PFA.
Bind parameter option is not show..
I have try below solution:-
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parametersHello,
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.
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?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.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 !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
inside model view=>Properties of Date column => Advanced => Bind to Parameter option not visible please help
Same here. I have done everything recommended and still see no option to bind.
Hi,
I think this feature of PBI works only with data sources from Microsoft.
I suggest please try with SQL Server database if you have a test instance.
