Bind to parameter is missing in modelling advanced properties for parameter

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.