Bind to parameter is missing in modelling advanced properties for parameter

[Anonymous]

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

Thanks,

Sahana

[markus_LE]

I had the same issue.

My requirement was to provide a list to the user where he selects a value which is the parameter to load a certain file depending on the filename.

I had only import queries. So in data modelling the bind parameter wasnt showing.

I just added one completely useless DQ query. The "bind parameter" showed up. I could take my parameter from the drop down. But it didnt worked. I went back to the data modelling and even though my table has a parametrized icon the parameter wasnt any longer in the drop down.

I went back to power query editor and changed the name of the parameter. Then it showed up again but still no functionaltiy.

I started a completely new report with the same logic but with DQ to a SQL Server and added the Parameter in the where clause. Everything works as expected. I can choose the value from a list which has the parameter binded and the report updates filtered by this selection.

So obviously there are data connection / data source restrictions but in my first scenario this "bind paramter" showup was very strange and somehow buggy.

[Anonymous]

Hi @Anonymous ,

As @amitchandak said, Dynamic M query parameters  (Bind to parameter option) is only available for some Direct Query source.

There are some considerations and limitations to consider when using dynamic M query parameters:

• A single parameter cannot be bound to multiple fields nor vice-versa.

• The feature is only supported for M based data sources. The following DirectQuery sources are not supported:

  • T-SQL based data sources: SQL Server, Azure SQL Database, Synapse SQL pools (such as Azure Synapse Analytics (formerly SQL Data Warehouse)), and Synapse SQL OnDemand pools
  • Live connect data sources: Azure Analysis Services, SQL Server Analysis Services, Power BI Datasets
  • Other unsupported data sources: Oracle, Teradata, and Relational SAP Hana, PostgreSQL
  • Partially supported through XMLA / TOM endpoint programmability: SAP BW and SAP Hana

• Aggregations are not supported with the feature

• Row-level security (RLS) is not supported with the feature

• Parameter names cannot be reserved words in DAX nor contain spaces. Appending "Parameter" to the end of the parameter name can help avoid this limitation.

For more information, please refer to

Dynamic M query parameters in Power BI Desktop (preview) - Power BI | Microsoft Docs

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

[amitchandak · Accepted solution]

@Anonymous , are you using a direct query? I think this  option is for direct query

refer

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

[MacBI]

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

[Anonymous]

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.